How to write query to select the record froma a table1 and after insert in table2 delete from the table1.

[former_member280467]

Hi,

Please help in writing a query for sender JDBC adapter ..

Can anyone please help to write a query for sender JDBC adapter to select the records based on two keys in table1 and  insert into table2 and delete the records from the table1.

Thanks,

Pawar.

[Former Member]

Hi,

        Is this the requirement at the sender side (JDBC) or is it the end to end scenario requirement?

For the former, you need to implement a stored procedure at the sender jdbc to achieve the functionality.

Search in sdn for stored procedures on sender jdbc.

Regards