Purpose
Defines the SQL Descriptor Area (SQLDA) in a C or PL/I application program.
Invocation
Nonexecutable preprocessor declaration.
Embedded SQL only.
Syntax
INCLUDE SQLDA
ANSI Compliance
INCLUDE SQLDA is a Teradata extension to the ANSI/ISO SQL:2011 standard.
Authorization
None.
Rules for Using INCLUDE SQLDA
- Either an INCLUDE SQLDA statement or an equivalent user-supplied declaration of the SQL Descriptor Area is required in every application program that uses dynamic SQL.
- The complete SQLDA statement, including the EXEC SQL prefix and the appropriate terminator, must be coded on one line.
Only a pad character can separate the words of the statement.
No other statements can appear on the same line.
- Preprocessor2 replaces the INCLUDE SQLDA statement with the appropriate language definition of the SQL Descriptor Area.
- For PL/I applications, the SQLDA declaration is defined as a based structure with a varying (REFER) substructure. This makes it suitable for use with multiple SQL Descriptor Areas.
- For COBOL applications, you cannot use INCLUDE SQLDA statements because COBOL does not support based structures.
As a result, if a COBOL program requires one or more SQL Descriptor Areas, you must code them yourself and insert them into the WORKING STORAGE SECTION of the program.
Related Topics
For more information about using INCLUDE SQLDA SQL Descriptor Area (SQLDA).