Programming Languages White Papers
Exchange Data Using Arrays in SQL PL: New Capabilities for Exchanging Data Between Applications and Stored Procedures
Overview IBM DB2 9.5 for Linux, UNIX and Windows introduces support for array data types in SQL Procedural Language (SQL PL). In addition to being useful as a data structure to develop algorithms, arrays are particularly useful in SQL PL as a vehicle for exchanging collections of data between applications and stored procedures and between stored procedures and relational statements. This paper gives the user an overview of arrays in SQL PL and includes examples that illustrate the different operations on arrays, the different ways of creating array values, and the use of arrays on the client side. One will also see a brief comparison of DB2's arrays with the VARRAY data type supported in Oracle.
| Publisher | IBM | File Format | HTML |
|---|---|---|---|
| Date Published | October 2007 | Downloads | 4 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 6 out of 9 users found this white paper useful
White Paper RSS
Download
Register
