Page 1 of 1
DB2 sequence
Posted: Tue Aug 03, 2010 1:03 pm
by 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 .
Re: DB2 sequence
Posted: Tue Aug 03, 2010 1:29 pm
by MT
developeretl wrote: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
Re: DB2 sequence
Posted: Tue Aug 03, 2010 2:58 pm
by 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