DSXchange

Hi

I need to generate a unique sequence number for each row of ouput(starting from 1 and increment is 1). Is it possible, if yes can you please let me know the code in detail

Thank you
Srini

Do a search in this forum. This has been answered earlier.

Actually probably not in this particular forum, which is devoted to WebSphere Transformation Extender (which used to be called DataStage TX, but which is no longer a part of DataStage).

You can do 2 ways:

1. When you invoking the functional map pass INDEX($), this value will be incremented for every functional map call.

2. Use GETANDSET() function.

Thanks