Difference

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vbalacts
Participant
Posts: 31
Joined: Wed Jan 08, 2003 7:30 pm

Difference

Post by vbalacts »

Hi All,
Can anyone tell me the difference between @OUTROWNUM and @INROWNUM? I have used both variables for sequence number generation and I dont find any difference between them. Can anyone help me on this?

Thanks,
Bala
cmueller
Participant
Posts: 46
Joined: Wed Oct 23, 2002 7:10 am

Post by cmueller »

@INROWNUM is the number of rows coming in and @OUTROWNUM is the number coming out per link.If all rows go through then they will be the same. But if you put a constraint for example on an output link, then they will be different.
vbalacts
Participant
Posts: 31
Joined: Wed Jan 08, 2003 7:30 pm

Post by vbalacts »

Thanks cmueller. SO, if i want to generate sequence number where there are some constraints in the Transformer, then I have to use @OUTROWNUM. Is this right?

Thanks,
Bala
cmueller
Participant
Posts: 46
Joined: Wed Oct 23, 2002 7:10 am

Post by cmueller »

Yes, that is correct.
Post Reply