Insert data into database using primary key

[Former Member]

How I can write the quiery based on primary key, before inserting the data into the database in Receiver JDBC Adapter?

[baskar_gopalakrishnan2]

You cannot do SQL SELECT QUERY first to get primary key information and use that for insert in the same structure .If you need to know the primary key information before doing insert do this way. Use JDBC graphical lookup function during mapping with SELECT QUERY and use that result like primary key information in the receiver JDBC structure. This is one option.

[Former Member]

hi,

How I can write the quiery based on primary key, before inserting the data into the database in Receiver JDBC Adapter?

we cont write any Query in Receiver jdbc adapter and can i know that what is your scenario and Requrement?

thanks