The following SQL statements are supported in the Data Division:
SQL INCLUDE
SQL declarations
For example:
EXEC SQL INCLUDE SQLCA END-EXEC.
EXEC SQL INCLUDE SQLDA END-EXEC.
EXEC SQL INCLUDE filename END-EXEC.
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
... SQL declarations
EXEC SQL END DECLARE SECTION END-EXEC.
Standard SQL INCLUDE Files
The standard SQLCA and SQLDA INCLUDE files are built into the pre-compiler and are included whenever they are named in the source. These files include specific adaptations for AcuSQL. Do not attempt to substitute other versions of these files.
HOST-VARIABLES
The term "host-variable" describes any data item defined in an SQL DECLARE section of Working-Storage. Host-variables are often used in SQL statements and must be preceded with a colon (":"). For examples of their use in a CONNECT statement, see section 2.4.