IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Insert records into multiple tables

  • 1.  Insert records into multiple tables

    Posted Thu February 27, 2003 03:19 AM

    Hi ,

    Could somebody tell the best way to insert records into multiple tables from a XML doc(all the tables are related 1-n relationship).

    Thanks in Advance,
    Anu


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: Insert records into multiple tables

    Posted Fri February 28, 2003 08:06 AM

    Hi,
    If you are using SQL server, you can create a stored procedure to insert data in the xml document to multiple tables. I am not sure which other DB has this functionality.
    Another way is to do multiple execsql statements to do a manual insert into multiple tables.
    Good Luck!


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


Related Content