DB2 Adapter - Stored Procedures with output parameters RRS feed

  • Question

  • Hi

    We have a DB2 stored procedure that has 3 input parameters and 2 output parameters, we can not get the Add Adapter Meta Data option to generate a schema when we have an output parameter from the DB2 Stored Procedure.

    BizTalk 2013 / HIS 2013 - no CU's applied as its a dev environment for experimenting 

    It works OK if we call a Stored procedure that does a select a returns a recordset.

    Has anyone else tried this?

    I was expecting it to work the same as the WCF-SQL adapter when you declare a stored procedure to have a OUTPUT variable



    • Edited by Mal_K Thursday, August 9, 2018 1:19 AM
    Tuesday, August 7, 2018 11:48 PM