DB2 ARRAY TYPES and Stored Procedures

Posted by stoned99 on 13-Mar-2017 17:25

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

Posted by Avadhoot Kulkarni on 13-Mar-2017 23:49

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.

This thread is closed