DB2 ARRAY TYPES and Stored Procedures - Forum - DataDirect Connect - Progress Community

DB2 ARRAY TYPES and Stored Procedures


DB2 ARRAY TYPES and Stored Procedures

This question is not answered

Does anyone know if the user-defined ARRAY data type in DB2 11 is supported as a parameter type when calling a stored procedure using CONNECT ADO.NET 4.2


Page 501 of https://publib.boulder.ibm.com/epubs/pdf/dsnapn01.pdf shows how to setup the Stored Procedure to use the custom types but I cannot get by ADO.NET program to send the string of Array data as a parameter.

I found reference to a type 


in this example


All Replies
  • Connect for ADO.NET 4.2 DB2 Provider currently do not support Binding Array as Parameter type for stored procedure.

    Please submit an idea for the same.

    Thanks and Regards,

    Avadhoot Kulkarni
    Lead Principal Software Engineer
    Progress Software Development Private Ltd.