Retrieving array values - IBM DB2 9.7 for Linux, UNIX, and Windows

Retrieving array values using an index
Retrieving array element values can be done directly by referencing the array and specifying a sub-index value.

Retrieving the number of array elements
Retrieving the number of array elements in a simple array can most easily be done by using the CARDINALITY function and retrieving the maximum allowed size of an array can be done using the MAX_CARDINALITY function.

Retrieving the first and last array elements (FIRST, LAST functions)
Retrieving the first and last elements in a simple array can most easily be done by using the FIRST and LAST functions.

Retrieving the next and previous array elements
Retrieving the next or previous elements in a simple array can most easily be done by using the PREV and NEXT functions.