SQL Descriptor Area (SQLDA)

The SQL Descriptor Area (SQLDA) is a data area that holds information about dynamic SQL commands. An SQLDA might be used in a DESCRIBE statement to find out information about columns returned by a query, and then reused for a FETCH statement when the values are actually selected.

The SQLDA consists of four variables, followed by a variable number of SQLVAR structures. SQLVAR structures describe columns if OPEN, FETCH or EXECUTE statements are involved. For DESCRIBE and PREPARE statements, the SQLVAR structures describe host variables.

This topic provides descriptions of the information provided in the SQLDA and shows the structure for COBOL, PL/I and C.

More: