Skip to Content
avatar image
Former Member

HOW INSERT DATA INTO MULTIPLE TABLES

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 08, 2007 at 10:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 10:20 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 10:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08, 2007 at 10:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 10:25 AM

    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 Document" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2007 at 10:25 AM

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

    Multiple records as a single transaction in JDBC Receiver Adapter

    Add comment
    10|10000 characters needed characters exceeded