SQL/MP Programming Manual for C

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for C—429847-008
6-17
Running the SQL Compiler in the Guardian
Environment
NOOBJECT directs the compiler to perform checking functions and to generate an
EXPLAIN listing if you have also specified the EXPLAIN option but to not produce
SQL object code.
RECOMPILE | NORECOMPILE
specifies whether the program should be automatically recompiled, if necessary,
during program execution.
RECOMPILE (the default) directs the SQL executor to automatically recompile a
program whenever any of these conditions occur:

The program file is SQL invalid at SQL load time.

The DEFINEs at SQL load time are different from the DEFINEs used during
explicit SQL compilation.

The timestamp check fails for an SQL object in an SQL statement.

An access path (index) is unavailable.
If the program uses the similarity check, automatic recompilation might not occur.
For more information, see Section 8, Program Invalidation and Automatic SQL
Recompilation.
NORECOMPILE directs the SQL compiler not to automatically recompile the
program. If any of the conditions described under the RECOMPILE option occur
during execution, an error is generated and the program is subject to explicit SQL
recompilation for validation.
RECOMPILEONDEMAND | RECOMPILEALL
specifies whether the SQL executor should recompile an entire invalid program or
only those SQL statements that require recompilation and are actually run. If you
specify NORECOMPILE, this option is ignored.
RECOMPILEONDEMAND directs the SQL executor to recompile only those
statements in the invalid program that actually run. Automatic recompilation occurs
the first time an individual SQL statement is run.
RECOMPILEALL (the default) directs the SQL executor to automatically recompile
the entire program if it is invalid. Automatic recompilation occurs at SQL load time.
REGISTERONLY { ON | OFF }
directs the SQL compiler to register a previously SQL compiled program in a
specific catalog without recompiling the program. To use the REGISTERONLY
option, you must have SQL/MP software version 310 (or later).
REGISTERONLY 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