Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

INCLUDE statement [ESQL]

Includes a file into a source program to be scanned by the SQL preprocessor.

INCLUDE filename
filename : SQLDA | SQLCA | string

The INCLUDE statement is very much like the C preprocessor #include directive. The SQL preprocessor reads an Embedded SQL source file and replaces all the Embedded SQL statements with C-language source code. If a file contains information that the SQL preprocessor requires, include it with the Embedded SQL INCLUDE statement.

Two file names are specially recognized: SQLCA and SQLDA. The following statement must appear before any Embedded SQL statements in all Embedded SQL source files.


This statement must appear at a position in the C program where static variable declarations are allowed. Many Embedded SQL statements require variables (invisible to the application developer), which are declared by the SQL preprocessor at the position of the SQLCA include statement. The SQLDA file must be included if any SQLDAs are used.



Side effects


  • ANSI/ISO SQL Standard

    Not in the standard.