Page 1 of 1
Alternative to @INROWNUM system variable
Posted: Mon Dec 17, 2007 1:41 am
by prematram
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..?/
Posted: Mon Dec 17, 2007 2:04 am
by Dev_help
If you want to generate a series of unique sequence numbers, then you may use a surrogate generator stage.
Posted: Mon Dec 17, 2007 4:55 am
by ArndW
@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
Re: Alternative to @INROWNUM system variable
Posted: Mon Dec 17, 2007 7:04 am
by Minhajuddin
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.