Search found 50 matches

by arnabdey
Thu Jan 11, 2007 3:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Value from routine in routine activity
Replies: 9
Views: 2614

Use Ans

Hi From the routine you can retrun a value by giving the following Ans=..... at the end The value is returned only if it is a transform type routine. Now it's output trigger should be Unconditional.... [b]NOT[/b] Ok (Conditional). In any subsequent stages you can access the value by <Routine Stage N...
by arnabdey
Thu Jan 11, 2007 3:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment Variable- Refresh
Replies: 14
Views: 4911

Password can be set with $PROJDEF

Hi Munish

I think you brought up the issue of not being able to use the password with $PROJDEF in some other place. You can do one thing.... Whenever you type the default value for password, type it as $PROJDEF only. You will be able to enter it in encrypted format only (*s). But you can use that.
by arnabdey
Thu Jan 11, 2007 2:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RPC daemon is not running (81016)
Replies: 5
Views: 3493

Hi

Please try out
netstat -a | grep dsrpc
and check the following entry
tcp4 0 0 *.dsrpc *.* LISTEN
ie whether the dsrpc daemon is listening
by arnabdey
Thu Jan 11, 2007 1:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to add one day to a Timestamp in PX
Replies: 4
Views: 3976

Using Julian date

You can use this

StringToTimestamp(DateFromJulianDay((JulianDayFromDate(Left(DSLink3.timstm, 10))+1)):Right(DSLink3.timstm,9))

where DSLink3.timstm is the input timestamp.
by arnabdey
Thu Jan 11, 2007 1:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: $ENV issue
Replies: 9
Views: 3984

Hi Munush We can use passwords (ie encrypted data formats) with $PROJDEF. I have used it. You just need to imprt the variable and in the encrypted format itself (ie with *s) you need to enter $PROJDEF. I am sure it will work. Arnab [quote="Munish"]Hi, I faced the same problem but get it so...