Search found 3 matches

by Mat05
Thu Nov 13, 2003 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: System variable @INROWNUM compare with decimal
Replies: 5
Views: 5615

Ok...this is weird. I tried testing if (@INROWNUM < 30)... and it worked! Same for 300, 3000, 30000 but it does not work for 300000!!!! The variable holding @INROWNUM is uint64 .....isn't it 64 bits long?? It should handle 300000 without problems! Anyway, I will keep it like that. Thanks for your he...
by Mat05
Thu Nov 13, 2003 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: System variable @INROWNUM compare with decimal
Replies: 5
Views: 5615

System variable @INROWNUM compare with decimal

Hi all, I am trying to test the variable @INROWNUM in a transformer stage against a number like the following: If (@INROWNUM <= 300000) Then "2003-12-21" else if (@INROWNUM < 600000) And @INROWNUM > 300000) Then "2003-12-28" else "2004-01-04" . The job works fine but ev...
by Mat05
Wed Oct 29, 2003 12:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access to environment variable inside routine
Replies: 4
Views: 2354

Yes, you answered it. I used DSExecute and got my variable.

Thanks a lot

Mat