Collection, record, and object types (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 varrays, associative arrays, and record types. The DB2 server accepts the syntax for the creation of PL/SQL nested tables and object types, but maps nested tables to associative arrays and object types to records.