DB2 Version 9.7 for Linux, UNIX, and Windows

Collections (PL/SQL)

The use of PL/SQL collections is supported by the DB2® data server. A PL/SQL collection is a set of ordered data elements with the same data type. Individual data items in the set can be referenced by using subscript notation within parentheses.

In PL/SQL contexts, the DB2 server supports both the VARRAY collection type and associative arrays.