Hi ,
I am new to datstage server.I have one question on @INROWNUM
in one of our existing jobs, the derivation in transformer is like this
COLUMN1 -If @INROWNUM = 1 Then "XYZ" else 'do something else here'
here my question is ,
first time when I ran the job I saw the first record with the value 'XYZ' for the column ' COLUMN1' for remaining 9 records it had someother values.
when I ran the second time, I don'see any record with the value 'XYZ'
Can you please explain me the reason
Thanks
Durga
@INROWNUM
Moderators: chulett, rschirm, roy