Purpose
Specifies the level of checking to be performed on embedded SQL statements.
Usage Notes
Option | Description |
---|---|
FULL | Specifies that syntax, object references, and privileges checking are performed on embedded SQL statements. This is the default. Use it whenever ENTRY or INTERMEDIATE for SQLFLAGGER is specified. |
NOSYNTAX | Specifies that no checking is to be performed on embedded SQL statements; and no syntax, object reference or access rights checking is performed. Specifying the NOSYNTAX option to the SQLCHECK parameter disables the logon to the database during the precompile phase. It has no effect on runtime. If both NOSYNTAX and a SQLFLAGGER of ENTRY are specified, PP2 generates an error and uses the default SQLFLAGGER value of NONE. |