on 05-28-2007 11:50 AM
<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>
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.