JDBC sender channel select and update query

[Former Member]

Hi,

In JDBC sender channel, can I write a select query inorder fetch records from 3 different tables from same sender server.

I also need to update these 3 different tables once the records are fetched.

Thanks and Regards

Suma

[Former Member]

Hi Suma,

>>In JDBC sender channel, can I write a select query inorder fetch records from 3 different tables from same sender server.

Yes you can do the same in single channel by writing a select query using joins .

>>I also need to update these 3 different tables once the records are fetched.

Updating simultaneously 3 different tables in a single query wont be possible.

Please go through the below link.

http://scn.sap.com/thread/3288530

Regards

Venkat

[MichalKrawczyk]

Hi,

in sender JDBC channel you can use stored procedures (except from oracle where you need "fix" to do that), you can do whatever you need in the stored procedure,

Regards,

Michal Krawczyk