Equivalent of system variable @INROWNUM

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
saraswathi
Participant
Posts: 33
Joined: Wed Jun 20, 2007 1:13 am

Equivalent of system variable @INROWNUM

Post by saraswathi »

i'm converting a server job into parallel job. i want a equivalent for @INROWNUM=1
(to get first row)
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The same system variable exists in Parallel. But each node has it's own @INROWNUM, so in order to get a unique number you will have to use the variable for the partition number as well (I'm not at a DS client now so cannot check what that variable name is, but you can find it in the drop-down menu)
Havoc
Participant
Posts: 110
Joined: Fri Nov 24, 2006 8:26 am

Post by Havoc »

ArndW wrote:The same system variable exists in Parallel. But each node has it's own @INROWNUM, so in order to get a unique number you will have to use the variable for the partition number as well (I'm not at a DS client now so cannot check what that variable name is, but you can find it in the drop-down menu)
System Variable for Parition Number would be @PARTITIONNUM
Post Reply