Defines the SQL Descriptor Area (SQLDA) in a C or PL/I application program.
ANSI Compliance
INCLUDE SQLDA is a Teradata extension to the ANSI/ISO SQL:2011 standard.
Required Privileges
None.
Invocation
Nonexecutable preprocessor declaration.
Embedded SQL only.
Syntax
INCLUDE SQLDA
Usage Notes
- 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.