How to generate sequence number from transformer

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
srinivas Guduru
Premium Member
Premium Member
Posts: 38
Joined: Sat Dec 29, 2007 9:58 am

How to generate sequence number from transformer

Post by srinivas Guduru »

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
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Post by vinothkumar »

Do a search in this forum. This has been answered earlier.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
wtx_dev
Participant
Posts: 10
Joined: Wed Jul 18, 2007 7:40 am

Post by wtx_dev »

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
Post Reply