6. Dynamic OpenSQL : The SQL Descriptor Area (SQLDA) : Including the SQLDA in a Program
 
Share this page                  
Including the SQLDA in a Program
To define the SQLDA, your application must issue the following INCLUDE statement:
EXEC SQL INCLUDE SQLDA;
Do not place this statement in a declaration section.
In most languages, this statement incorporates a set of type definitions that can be used to define the SQLDA structure. In some languages, it actually declares the structure. If the structure is declared directly (instead of using the INCLUDE statement), you can specify any name for the structure. For information about how your language handles this statement, see the Embedded SQL Companion Guide.
A program can have more than one SQLDA‑type structure. A dynamic FRS DESCRIBE statement and a dynamic OpenSQL statement can use the same SQLDA structure if the described fields or table field columns have the same names, lengths, and data types as the columns of the database table specified in the dynamic OpenSQL statement.