Multiple library lists or schemas, and BizTalk DB2 adapter is not calling the correct one. RRS feed

  • Question

  • We have multiple 'schemas' or as others call library lists and I need to be able to re-direct where it is going:

    In the connection string, I have set the default schema to CC1 and am calling the stored procedure SPTESTSP

    Here are the results when running through iNavigator:


    returns 12 rows


    returns 12 rows


    returns 15 rows

    Of course BizTalk is returning the 15 rows stored procedure.

    Even if I put in the xml request CC1.SOTESTSP, it still returns 15 rows.

    Where is this 'randomness' defined?

    • Edited by Eric Stott Wednesday, October 10, 2012 7:24 PM
    Wednesday, October 10, 2012 7:24 PM