** Is it possible to update more than 1 table in JDBC sender CC.

[jegathees_waran]

Hi Friends,

Based on select condition, is it possible to update more than one table by using the 'Update SQL statement' in the JDBC sender Communication Channel.

From help.sap.com, I understand that only UPDATE, INSERT, DELETE command are possible in the 'Update SQL statement'. But, these commands are used to work with only one table.

But, how do we update multiple tables? (Will we do these the same in 'Query SQL Statement')

Any idea ?

Kind Regards,

Thanking you.

Jeg P.

[Former Member]

Hi,

Yes You can modify or update one or more database tables using your JDBC SQL format. Below is the SAP information.

You can modify one or more database tables by means of a message. Depending on the content of the message, you can either insert (INSERT), update (UPDATE), or delete (DELETE) the data. Results from queries (SELECT) can also be included in the response in XML format for synchronous messages.

If you want to see the example message type at the below link.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Thanks,

Bala

[GabrielSagaya]

Hi bala,

This is not possible on sender JDBC to update values on more than 1 table.

if so please write the query for the Update statement??

[Former Member]

Hi,

Using Sender JDBC Adapter, we can not update more than one table. To be more specific, we can update only those records fetched by Select statement.

Using Receiver JDBC Adapter, we can manipulate more than one table.

Regards

Bhanu

Intelligroup.

[GabrielSagaya]

In Receiver side JDBC you can use update/insert records into multiple tables by using Join / Stored Procedures.

But

There is no possible to update more than 1 table in JDBC sender CC.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[agasthuri_doss]

Hi JP,

Adding to Gabriel comment,

To my knowledge it is not possible from Sender JDBC Adapter to Update more than one table with help of One Channel.

As Bhanu Tiruveedula mentioned For Receiver JDBC Adapter we can go ahead with more than one table

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Agasthuri Doss

Edited by: Agasthuri Doss Baladandapani on May 6, 2008 8:44 AM