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

DB2 ARRAY TYPES and Stored Procedures

 Forum

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

ibmsystemsmag.com/.../

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 

DB2Type.DynArray

in this example

www.glasch.de/.../

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.