Additional support for arrays

Db2 12 enhances array support in SQL statements.

Db2 for z/OS Db2 11 provided support for defining and manipulating arrays within SQL PL routines, and for passing arrays as parameters between routines.

Array support in Db2 12 adds the following enhancements:

• The ability to define a global variable as an array type. A global variable that is defined as an array type can be manipulated within an SQL PL context, or outside an SQL PL context.
• The following ARRAY_AGG function improvements:
  • ARRAY_AGG can be invoked without an ORDER BY clause.
  • ARRAY_AGG can be used with associative arrays.