DB2 sequence

[developeretl]

Hi,
I need to generate sequence from the db2. Iam having 2 columns and the sequence applies to both. Can you tell me how do I implement this through Transformer stage as processing stage between the input db2 and outout db2 .

[MT]

Hi,
I need to generate sequence from the db2. Iam having 2 columns and the sequence applies to both. Can you tell me how do I implement this through Transformer stage as processing stage between the input db2 and outout db2 .

Hi

sometime a little more input is required to understand what you intend to do
or what you understand under a "sequence"....

Then the answer will be a little more helpful as well.

regards
Michael

[developeretl]

I need to generate a sequence in the output database but using the bd2 query it should be incremented . It should the update the database
I have two columns which are dependent on the generated sequence in the database

I/P O/P
gen_seq 0
gen_seq 1
gen_seq 2