Updating two tables through JDBC

[Former Member]

<b>Hai,

Can anybody please answer the following question?

How can I update two table in Receiver by using JDBC Adapter at receiver side from single source structure.

Thanks in advance.</b>

[Former Member]

Hi ,

Create following structure for inbound data type to insert data in DB using JDBC receiver adapter here dbTableName1 is for first table and dbTableName2 for second table .

<StatementName2>

<dbTableName1 action="UPDATE_INSERT">

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName1>

<dbTableName2 action="UPDATE_INSERT">

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName2>

</StatementName2>

Thanks ,

Suvarna

pls award pts if it helps

[bhavesh_kantilal]

Create multiple STATEMENT level tags one for each table to be updated with the Action as UPDATE and the Access Containing the corresponding Column Names.

Refer this link for the details,

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

Regards

Bhavesh

[Shabarish_Nair]

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

use the document format for the receiver JDBC to update into multiple tables !!!

Further reference - http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm