difference b/w @INROWNUM and @OUTROWNUM

[singhald]

hello friends

can u tell me wht is the difference b/w @inrownum and @outrownum.
and where @INROWNUM and @OUTROWNUM are used in the Datastage job.

Thanks

Singhal

[kcbland]

In the transformer stage, the primary input stream sets the variable @INROWNUM to be the row count of the data coming into the stage on that link.

For each output link, there exists an @OUTROWNUM value that is the row count for all rows that have met the constraint condition to go down that link. So, if you have 1 link in and 3 links out, @INROWNUM will always be the number of rows to process. Each output link can have a different @OUTROWNUM value during processing because of that particular links constraint.

[roy]

Hi,
The @INROWNUM is the sequential number of rows as they come into the transformer stage where @OUTROWNUM is the sequential number of rows going out a specific link from the transformer.

If you put constraints on a certain link in a transformer then the values of those two variables will not be the same.

You can use the two variables within the scope of the transformer stage.

IHTH,