Describe Statement
The DESCRIBE statement describes a prepared SQL statement into a program descriptor (SQLDA), which allows the program to interact with the dynamic statement as though it was hard coded in the program. This statement is used primarily with dynamic SELECT statements.
The syntax for the DESCRIBE statement is as follows:
EXEC SQL DESCRIBE statement_name INTO|USING descriptor_name;
For more information about the describe statement, see
Describe Statement and SQLDA (see page
Describe Statement and SQLDA) and
Preparing and Describing Select Statement (see page
Prepare and Describe Select Statements).