Support for arrays
Db2 11 includes array support in SQL statements.
This support makes it easier to exchange long lists of values with the data server. Array support on Db2 for z/OS® is compatible with the support that is offered on other members of the Db2 family of products.
With array support in Db2 11 you can do the following tasks:
- Define arrays as parameters and variables for SQL routines
- Pass arrays from one procedure to another as arguments for input or output parameters
- Pass arrays to functions as parameters or from functions as return values
- Manipulate arrays, transform arrays to tables, and transform tables to arrays by using new built-in functions