How to get increment of a value..

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinath51
Participant
Posts: 61
Joined: Wed Aug 31, 2011 10:47 am
Location: United States

How to get increment of a value..

Post by srinath51 »

Hi All,

i have a requirement i.e; i am generating a text file with a column named - "SEQNO" & other column is " BUSS UNIT"

there are three rows for the output file and i want the following data for the three rows . the first row for the column - "SEQNO" is 00009999 (Default value) and the next rows will be increment by 1 i.e;00010000 and the last row as 00010001.

that increment depends on the other column i.e; "Buss unit",so when the Buss unit changes the value "SEQNO" will increment by 1.
Sri.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Maintain SEQNO in a stage variable. Use other stage variables to detect change in BUSS_UNIT. Increment SEQNO only if BUSS_UNIT changes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
srinath51
Participant
Posts: 61
Joined: Wed Aug 31, 2011 10:47 am
Location: United States

Post by srinath51 »

thanks will give a try...
Sri.
Post Reply