HOW INSERT DATA INTO MULTIPLE TABLES

[former_member1275317]

hi

i hav a scenario in which i need to update customer details in two tables using JDBC adapter without using BPM...

do i need to take care about target sturcture..in this case..

pls give me answers ASAP

thnks

satya

[Former Member · Accepted solution]

Hi Sathya,

I hope you can do this with Procedures. So procedures can have multiple statements and by this way you can update how many tables you want to update you can do.

Warm Regards,

Vijay

[Former Member]

see the discussion, its same query (Pua Ming Fei ) as urs::;

[former_member192892]

Hi,

Please use stored proceedure to create an SQL update statement for two tables. Give the necessary arguments you need to give in the stored proceedure.

From <a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

Choose the one for Stored proceedures i.e EXECUTE and map your XI Payload to the arguments as required..

It should do the job

Thanks

[Shabarish_Nair]

Ref:

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

you need to have multiple ACCESS level tags in the output one for each Record. This will Update multiple records in the Database.

The ACCESS tag occurence should be 0 to unbounded and each record in the source should create a ACCESS level tag with the corresponding lower level tags.

[Former Member]

Hi Satya,

the best practice is to use stored procedure in jdbc sceanrio as you can implement complex logics in stored procedue.. you can extend procedure as you want without disturbing XI code... so use stored procedure to insert data into two tables..

Ranjeet.

[Former Member]

Hi Satya,

This link would help you

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

regards,

Ravi