cancel
Showing results for 
Search instead for 
Did you mean: 

How to send data into two table (oracle system )

Former Member
0 Kudos
55

Hi

Experts

How to send data into two table (oracle system ) .

from a single file structure at sender and reciver 2 tables should be updated

i need file structure for source as well as for reciver

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi aravind,

Document Formats for the Receiver JDBC Adapter

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

<StatementName2>
<dbTableName action=u201DINSERTu201D>
<!-- TABLE 1 -->
<table>realDbTableName_1</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>  
<!-- TABLE 2 -->
<table>realDbTableName_2</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>

</StatementName2>

Regards Mario

Former Member
0 Kudos

Hi,

Inserting data with single structure for two tables,Create a Statement with 0-Unbounded.Dublicate the Receiver Statment Structure.If you create access with 0-Unbounded then you can able to insert multiple records with each table.

<StatementName1>

<dbTableName action=u201DINSERTu201D>

<table>TABLE1</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName1>

Dublicate the statment.

<StatementName1>

<dbTableName action=u201DINSERTu201D>

<table>TABLE2</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName1>

Regards,

Prakasu

Former Member
0 Kudos

Hi Aravind,

There are two ways to do it.

1. You need to have two message mapping, add one more line in your interace determination.

2. Or in the same message mapping.

<Statement1>

<tag1>

<action>INSERT</action>

<table>Table1</table>

<access>

<field1>

<field2>

......

......

<Statement2>

<tag2>

<action>INSERT</action>

<table>Table2</table>

<access>

<field1>

<field2>

......

......

For more details on the sender and receiver structures check the below link. Also note action is an attribute.

http://help.sap.com/saphelp_nw70/helpdata/en/48/d5a1fe5f317a4e8e35801ed2c88246/frameset.htm

-Regards,

Shamly

Edited by: Shamly MM on Aug 14, 2008 4:01 PM