Setting SQL Option Background Syntax Checking Options

Before compiling an XDB application, you can set options that determine the level at which the XDB preprocessor checks syntax in the background. To do this, click one of the following options:

No checking

The preprocessor does not connect to the DBMS and does not validate EXEC SQL statements; however, the preprocessor does check host variables.

Basic

The preprocessor does not connect to the DBMS and does not validate EXEC SQL statements; however, the preprocessor does check simple SQL statements and host variables.

Complete

This option sends all embedded SQL statements to the DBMS for validation, and requires a connection to the DBMS used by the program. Select this option for database providers that do not require SQL statement execution to perform validation.