Alternative to @INROWNUM system variable

prematram · Post by **prematram** » Mon Dec 17, 2007 1:41 am

Hi,

Is bthere any altertnative to @INROWNUM system variable in parallel extender..bcoz it is not working in parallel.. what is the use of @PARTITIONNUM..?/

Dev_help · Post by **Dev_help** » Mon Dec 17, 2007 2:04 am

If you want to generate a series of unique sequence numbers, then you may use a surrogate generator stage.

ArndW · Post by **ArndW** » Mon Dec 17, 2007 4:55 am

@INROWNUM will give you the actual input row per partition, i.e. it is not unique. If you want a unique number, you will need to combine your @INROWNUM and your @PARTITIONUM

Minhajuddin · Post by **Minhajuddin** » Mon Dec 17, 2007 7:04 am

prematram wrote:Hi,

Is bthere any altertnative to @INROWNUM system variable in parallel extender..bcoz it is not working in parallel.. what is the use of @PARTITIONNUM..?/

What do you mean it's not working?
Give more details of your problem to help people help you.

DSXchange

Alternative to @INROWNUM system variable

Alternative to @INROWNUM system variable

Re: Alternative to @INROWNUM system variable