Idoc to jdbc scenario ?

[Former Member]

hi expertes

Hi i want to interst the data from r/3 to as/400 system . One idoc to 2 tables. can any body help me out on this. i am dooing this scenario in pi 7.1

myquestoins :

1. how to insert the idoc data into the db table ? (i just imported the tables as a 2 externel defenetions).?

i am not using the ( action ,table,acess )

2. in message mapping can i insert the data in to the tables (tb1,tb2,1:2) at time. ?

[prateek · Accepted solution]

You have to follow the same process as in PI 7.0. For inserting data into more than one tables you may use multiple statement tags

<Root>

<StatementName>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName>

</Root>

This has to be populated in mapping then.

Regards,

Prateek