DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
Array variables are variables based on user-defined array data types. Array variables can be declared, assigned a value, set to another value, or passed as a parameter to and from SQL procedures.
Array variables inherit the properties of the array data types upon which they are based. Array variables are used to hold a set of data of the same data type.
Local array variables can be declared within SQL procedures using the DECLARE statement.
Global array variables can be created using the CREATE VARIABLE statement.