Search found 5 matches

by rob1
Tue Dec 20, 2005 5:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Return Code 13 running dsjob on AIX
Replies: 1
Views: 1078

Return Code 13 running dsjob on AIX

Hi, When I run dsjob on Unix, the DataStage job seemes to run correctly but the command terminates with a return code 13 . the command is : dsjob -server birdprod -user XXX -password XXX -run -param JobName=JERT -param dirlog=/tmp -jobstatus dartydwh JC001RUNJOB.PRODL What does this return code mean...
by rob1
Fri Sep 16, 2005 10:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to compute the week of the month
Replies: 3
Views: 1413

How to compute the week of the month

How could I compute the week of the month for a date.
The week #1 begins on the first day of the month and end on the first sunday .
If somebody has a routine, let me know it
by rob1
Fri Nov 28, 2003 10:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: multiple instances of Db2
Replies: 4
Views: 2410

Thanks,
Is it possible to set another variable in the same way ?
What is the syntax ?

I have one job control which launches many other jobs who access to Db2.
Do I have to set these variables in the job control or in each job ?
by rob1
Wed Nov 26, 2003 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: multiple instances of Db2
Replies: 4
Views: 2410

multiple instances of Db2

How can we connect datastage jonb to different db2 instances ? eg : 1 job uses db2 instance a and 1 job uses db2 instance b Is it possible to modify dsenv to set variable DB2INSTANCE ? at first glance, it seems that this shell is executed only once when datastage server is set up, and not each time ...
by rob1
Wed Sep 03, 2003 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Current timestamp
Replies: 10
Views: 3305

Current timestamp

How can i do to have the timestamp for each row processed in my input stage ?
Functions Date(), time() and timedate() are based on the time where the job begins.
I need to have a unique time, even with milliseconds, for each row processed.
Thanks in advance.