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 .
DB2 sequence
Moderators: chulett, rschirm, roy
Re: DB2 sequence
Hideveloperetl 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 .
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
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
Re: DB2 sequence
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
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