Search found 97 matches

by atul9806
Sun Mar 18, 2012 2:37 pm
Forum: General
Topic: unable to connect to windows server from DataStage Unix Ser
Replies: 5
Views: 3133

Re: unable to connect to windows server from DataStage Unix

Hi
you can try this code :

Code: Select all

#!/usr/bin/ksh 
cd /local/apps/OutputFiles/PSC/ 
ftp -nvi us1003000.corpnet1.com <<EOF 
user USERNAME PASSWORD
cd /Home/RD_USER/Inbound 
ascii 
mput *.txt 
echo "Files Transfered Successfully" 
bye 
EOF

by atul9806
Sun Mar 18, 2012 2:09 pm
Forum: General
Topic: Which one is better to learn first ??
Replies: 2
Views: 1819

Which one is better to learn first ??

Hi friends... I dont know where this question should lie so posting here.. I am new to DataStage as a developer, I just stuck between server job and parallel, so just need your comment about to select a job for learning ?? Which one is better for learning first .. Server job or Parallel ??? As in my...
by atul9806
Sun Mar 18, 2012 2:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort stage is not wrking
Replies: 6
Views: 2933

yes guys, you are right... I got the sorted data in a flat file
thanks again :)
by atul9806
Wed Mar 07, 2012 2:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort stage is not wrking
Replies: 6
Views: 2933

Hi there
this is my sorting criteria. I am taking the input from the user
Image

Please help
by atul9806
Wed Mar 07, 2012 1:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort stage is not wrking
Replies: 6
Views: 2933

Sort stage is not wrking

Hi guys I am creating a server job, in which taking input from one table and applied sort stage to sort the table with a column and stor the data into other table job is running fine, but not sorting the table http://img254.imageshack.us/img254/8407/3fccf6ed757c9280.jpg I used the <column_name> <D> ...
by atul9806
Tue Mar 06, 2012 7:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp transform error
Replies: 3
Views: 2218

Sorry I didn't get you, where I have to change these settings
I already set this as timestamp(26,6)

Thx
by atul9806
Tue Mar 06, 2012 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp transform error
Replies: 3
Views: 2218

Timestamp transform error

Hi All I am new in DataStage designing. I have a problem with transforming the timestamp to date. I am using transformer stage to change the timestamp to date TIMESTAMP.TO.DATE(DSLink4.CREATE_TIMESTAMP) Input column = CREATE_TIMESTAMP, type = timestamp utput column = CREATE_DATE, type = date When I ...