5. Working with Embedded SQL : Dynamic Programming : Dynamic SQL Statements : Describe Statement
 
Share this page                  
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).