Defining SQL descriptor areas (SQLDA) in PL/I

If your program includes certain SQL statements, you must define at least one SQL descriptor area (SQLDA). Depending on the context in which it is used, the SQLDA stores information about prepared SQL statements or host variables. This information can then be read by either the application program or Db2.

Procedure

To define SQL descriptor areas:

Code the SQLDA directly in the program, or use the following SQL INCLUDE statement to request a standard SQLDA declaration:

EXEC SQL INCLUDE SQLDA

Restriction: You must place SQLDA declarations before the first SQL statement that references the data descriptor, unless you use the TWOPASS SQL processing option.