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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  Insert records into multiple tables

    Posted 02/27/03 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 02/28/03 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