DSXchange

Hi All,

Could you please explain me about the System Variables

1. @NUMPARTITIONS
2. @PARTITIONNUM

and want to know their behavior while generating a sequence number?

Hi,

@NUMPARTITIONS is the count of number of partition used in your job design. If your number of partitions are 4 then
@NUMPARTITIONS=4

@PARTITIONNUM will be 0 for first partition and 1 for second partition and so on.

Using @NUMPARTITIONS,@PARTITIONNUM and @INROWNUM you can generate formula to create sequence number in parallel job.

Hi Prasoon,

Do you mean the partitions as the no.of nodes used in the configuration file?

Yes