Actian X 11.1 | Describe Statement

OpenSQL Reference Guide > OpenSQL Reference Guide > Dynamic OpenSQL > Dynamic OpenSQL Statements > Describe Statement

Was this helpful?

Describe Statement

The DESCRIBE statement describes a prepared OpenSQL statement into a program descriptor (SQLDA) to allow 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 DESCRIBE statement has the following syntax:

EXEC SQL DESCRIBE statement_name INTO|USING descriptor_name;

For more information about the DESCRIBE statement, see The SQL Descriptor Area (SQLDA), and Preparing and Describing the Select Statement.

Last modified date: 11/09/2022