Get the inserted rows in database

[randomTN]

Hi,
I'm trying to insert a row into the database with DB2 connector, however there's a auto generated key in the table that's generated in the database.
I need to be able to fetch the inserted data to get the auto generated keys value.
If I put another DB2 connector to select the data from the table it execute before the insert happens.
I need to be able weather to get the inserted data in the database or to force data stage to run the DB2 connector that makes the select after the insert happens

[ray.wurlod]

Welcome aboard. This is not something you can achieve in a single parallel job.
However a server job may be your solution, as it supports the Connector having both an input and an output link.