How to fetch record from Db2 for given key
Posted: Wed Dec 15, 2010 6:04 pm
Hi
I am trying to pull the record from DB2 based on the key input from a transformer and my out put from DB stage is seq number for that key.
I am getting this key into another tranformer and all the values have been passed to the second transformer from first one and trying to insert the records with new Seq number for that key. I am getting cyclic dependency while compiling.
file-->trasnsformer1 -->one arrow goes to DB with key values as input and executing dummy sql--Executing select for Max seq number for given key and return the same to another transformer 2.
from transformer 1--> i have another arrow going towards transformer 2 with all the values ---> from here insert into DB.
Getting cyclic dependency.
Any thoughts what i am doing wrong here?
I am trying to pull the record from DB2 based on the key input from a transformer and my out put from DB stage is seq number for that key.
I am getting this key into another tranformer and all the values have been passed to the second transformer from first one and trying to insert the records with new Seq number for that key. I am getting cyclic dependency while compiling.
file-->trasnsformer1 -->one arrow goes to DB with key values as input and executing dummy sql--Executing select for Max seq number for given key and return the same to another transformer 2.
from transformer 1--> i have another arrow going towards transformer 2 with all the values ---> from here insert into DB.
Getting cyclic dependency.
Any thoughts what i am doing wrong here?