none
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


    -Dheer
    Tuesday, May 18, 2010 11:41 AM

Answers

  • 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.

    HTH

    Regards,

    Steef-Jan Wiggers
    MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    Saturday, June 26, 2010 10:03 AM
    Moderator