DSXchange

i'm converting a server job into parallel job. i want a equivalent for @INROWNUM=1
(to get first row)

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)

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