DB2 adapter issue RRS feed

  • Question

  • Hi , I need to use DB2 adapter to update some tables in As400 Db. I have around 15 table to insert.
    I tried to use updategram with multiple schemas in it , but later found that it will not work, bcs it is not designed for that.
    I cant have a SP bcs I am sending a XMl file to DB2 and we don’t have people to write the SP/RPG’s to run through it and insert… so this is also gone…

    Can someone suggest me any other options.
    I am actually thinking of using 15 updategrams and insert in to individual table, which I am able to but, no of hits is an issue and u need to open the connection those many time and it takes time. Though time is not a constraint for us…
    Can some on help me on this… ASAP

    Tuesday, May 18, 2010 11:41 AM


  • Hi,

    I think your only option is using the updategrams, but I would not executed them in parallel (same time) but in sequence with some delay in between them. Perhaps you can use something similar as described in this post.



    Steef-Jan Wiggers
    MCTS BizTalk Server
    If this answers your question please mark it accordingly

    Saturday, June 26, 2010 10:03 AM