Dynamic SQL is supported in PL/I, and the application must code the necessary SQL Descriptor Area (SQLDA) structures. For details on the SQLDA and its fields, see SQL Stored Procedures and Embedded SQL (B035‑1148).
Define the necessary SQLDA structure in one of two ways:
The generated SQLDA structure for a PL/I program is:
DCL 1 SQLDA BASED(SQLDAPTR),
2 SQLDAID CHAR(8) INIT(’SQLDA ’),
2 SQLDABC FIXED BIN(31),
2 SQLN FIXED BIN(15),
2 SQLD FIXED BIN(15),
2 SQLVAR(SQLSIZE REFER(SQLN)),
3 SQLTYPE FIXED BIN(15),
3 SQLLEN FIXED BIN(15),
3 SQLDATA PTR,
3 SQLIND PTR,
3 SQLNAME CHAR(30) VAR;
DCL SQLSIZE FIXED BIN(15);
DCL SQLDAPTR PTR;