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
  • 1.  SQL Insert AS400

    Posted Wed February 12, 2003 11:33 AM

    Hi,
    Could someone help me in the following problem:
    If I would like to Insert rows into an AS400 file via execSQL service, can I do it in one step for all the records stored in a record list, or I have to do it line by line.
    Thanks for any guidence in advance.
    Gabor


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: SQL Insert AS400

    Posted Wed February 12, 2003 02:07 PM

    If you are using execSQL, you will have to do it line by line. Try writing a stored procedure or something like that.
    Good Luck!


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods