@INROWNUM

Durga · Post by **Durga** » Mon May 14, 2007 1:21 pm

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

DSguru2B · Post by **DSguru2B** » Mon May 14, 2007 1:29 pm

You should get 'XYZ' everytime for the first incoming record. Change your output to a sequential file. If you have a hashed file then you might be overwriting it due to identical keys.

nick.bond · Post by **nick.bond** » Mon May 14, 2007 4:59 pm

add another column with the derivation of @INROWNUM. This may help you see what is happening.

Is this a Server job or EE job? You have said it is server but posted in the EE forum.