You can define array parameters in SQL procedures that you create on data connections to servers with DB2® Version 9.7 for Linux®, UNIX®, and Windows®, or later. You can use array parameters to manipulate a collection of values of a single data type.
An array parameter is defined by its array type. An array type is a system-defined or a user-defined data type that consists of an ordered set of elements of a single data type. All data types except XML and LOB (that is, CLOB, BLOB, and DBCLOB) can be used in array data types.
DB2 for Linux, UNIX, and Windows supports both ordinary array data types and associative array data types. The IBM® Database Add-Ins for Visual Studio support only ordinary array data types. An ordinary array data type has a defined upper bound on the number of elements and uses the ordinal position as the array index. Only single-dimension arrays are supported.
The mode of an array parameter must be IN (input only). You define an array parameter through the Array Type parameter property in the IBM Procedure Designer. The value of the property is an array data type that you select in the Array Types window.
You cannot define array data types in the add-ins. Array data types must be defined in the DB2 for Linux, UNIX, and Windows database on the connection. For information about defining array data types, see Creating an array data type (CREATE TYPE statement) in the DB2 Version 9.7 for Linux, UNIX, and Windows Information Center.
When you run a procedure in which IN and INOUT parameters are defined, the Run Options window opens so that you can specify values for the parameters. You specify values for array parameters in the Specify Array Values window, which you access through the Run Options window.
Procedure View, IBM Procedure Designer | Array Types | Running Procedures or Functions | Run Options | Specify Array Values