After a long time research I found out a solution.
Within the same connection and same transaction use tDB2Input with this select:
SELECT Identity_val_Local() as id FROM sysibm.sysdummy1
The Talend job is like this:
Wednesday, July 15, 2015
How to get last inserted id in DB2?
I have two tables in db2, one child, one parent. I would like to insert data into one table, and get the id (which auto generated in the db2,) then insert the id into another table as a foreign key by using ETL tool, Talend open studio.
After a long time research I found out a solution.
Within the same connection and same transaction use tDB2Input with this select:
The Talend job is like this:
After a long time research I found out a solution.
Within the same connection and same transaction use tDB2Input with this select:
The Talend job is like this:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment