How can i Configure JDBC Receiver Adapter to INSERT data in multiple tables

[Former Member]

Hi ,

I want to INSERT data in 4 diffrent tables.

Input Data Format is:

<H1>

<d1></d1>

<d2></d2>

</H1>

I want to insert <H1> Header data in particular table & all the details data<D1> in their corresponding table.

Note that Header Can't repeat but Details records are repeating again & again.

Is it possible to write Multiple INSERT STATEMENT in single Data Type.??

I mean to say can we write STATEMENT keyword again & again. if yes HOW ?

[Former Member · Accepted solution]

Hi Kulwinder,

Yes you can do this

and here is link to get into its detail.

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

thanks,

pooja

[Former Member · Accepted solution]

Thanks Pooja. I think this will work. Will get back to u if i faced any problem

[Former Member]

Hi

see below links.

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Regards

Chilla..