Sends each SQL statement to the database at compilation time.
CHECK requires that you also:
- Set the DB compiler directive option, or identify the database using the DB2DBDFT environment variable.
- If the connection to the database specified requires authentication, then the PASS compiler directive option is also required.
- When using SQL(CHECK) with an ODBC connection to Oracle, you must have at least the same user privileges as are required to
execute the SQL statements in the program.
|Used at compile time:
|Behavior at run time:
Scope - OpenESQL SQL Compiler Directive Options for more information.
Depending on your driver and/or DBMS and in certain circumstances, CHECK does not flag invalid SQL statements.
You can specify the [NOCHECK], [ALSO CHECK], or [WITH CHECK] statement prefix to affect specific SQL statements. See
SQL Statement Prefixes for CHECK Directive for complete information.