system variables @NUMPARTITIONS and @PARTITIONNUM : explain

moalik · Post by **moalik** » Thu Jan 22, 2015 1:37 am

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?

prasson_ibm · Post by **prasson_ibm** » Thu Jan 22, 2015 3:12 am

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.

moalik · Post by **moalik** » Thu Jan 22, 2015 3:41 am

Hi Prasoon,

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

prasson_ibm · Post by **prasson_ibm** » Thu Jan 22, 2015 5:50 am