Difference

dwandbi · Post by **dwandbi** » Thu Apr 20, 2006 8:30 am

What's difference between @INROWNUM and @OUTROWNUM in data stage system variables.

thanks,
Tom

ArndW · Post by **ArndW** » Thu Apr 20, 2006 8:32 am

The values are for different things; @INROWNUM is for the current row number coming into a transform stage for a link and @OUTROWNUM is the current row number going out of a transform stage down a given link. They can be identical but are not necessarily so.

kumar_s · Post by **kumar_s** » Thu Apr 20, 2006 8:37 am

That is... No of input rows need not to be same as no of output row for a link in transformer.

kcbland · Post by **kcbland** » Thu Apr 20, 2006 8:50 am

Primary input stream has --> @INROWNUM
Each output stream has --> @OUTROWNUM