SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-44
Running the SQL Compiler
ON
directs the SQL compiler to register a program in the specified catalog without
compiling the SQL statements in the program or creating a new program file.
The SQL compiler marks the program’s file label as SQL sensitive and SQL
valid. The program retains its existing execution plans. If the program was not
previously SQL compiled, the operation fails with SQL error 2115.
The CATALOG option is the only other SQLCOMP option you can specify with
the REGISTERONLY ON option. If you specify an option other than CATALOG,
the operation fails with SQL error 2111. If the program was previously compiled
with the NOREGISTER ON option, the operation fails with SQL error 2108. If
the program was modified by the Binder program or linker after it was SQL
compiled, the operation fails with SQL error 2103.
OFF
directs the SQL compiler to explicitly SQL compile the program and perform all
SQL compiler functions.
OFF is the default.
NOREGISTER
directs the SQL compiler to compile a program without registering the program in a
catalog. To use the NOREGISTER option, you must have an SQL/MP software
version of 310 (or later).
ON
directs the SQL compiler to explicitly compile the program but not to register it
in a catalog. The SQL compiler does not mark the program as SQL sensitive
and SQL valid in its file label. Therefore, the program file can be executed
without being registered in an SQL catalog. If you specify the CATALOG option
with the NOREGISTER ON option, the compilation fails with SQL error 2116. If
the program is already registered in a catalog, the compilation fails with SQL
error 2110. If the program was modified by the Binder program or linker after it
was SQL compiled, the operation fails with SQL error 2103.
OFF
directs the SQL compiler to explicitly compile the program and perform all
specified compiler functions, including registering the program in the catalog.
OFF is the default.
CHECK
determines the behavior of the SQL executor when it executes an invalid SQL
statement or a statement that references a DEFINE that has changed since the
last explicit SQL compilation. To use a CHECK option, you must have an SQL/MP
software version of 310 (or later).