SQL Supplement for H-Series RVUs

SQL/MP Programming Manual for COBOL
HP NonStop SQL Supplement for H-Series RVUs—529446-005
1-43
Running the SQL Compiler
RECOMPILE
directs the SQL executor to automatically recompile a program whenever any
of these conditions occur:
•
The program file is SQL invalid.
•
The DEFINEs used 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.
RECOMPILE is the default.
If the program uses the similarity check, automatic recompilation might not
occur. For more information, see Section 8, “Program Invalidation and
Automatic SQL Recompilation,” of the SQL/MP Programming Manual for
COBOL.
NORECOMPILE
directs the SQL executor 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 invoke the recompilation of an entire
invalid program or only SQL statements actually executed. If you specify
NORECOMPILE, this option is ignored.
RECOMPILEONDEMAND
directs the SQL executor to recompile only the statements in the invalid
program that are actually executed. Automatic recompilation occurs the first
time the individual SQL statement is executed.
RECOMPILEALL
directs the SQL executor to automatically recompile the entire program at SQL
load time if it is invalid. RECOMPILEALL is the default.
REGISTERONLY
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 an SQL/MP software version of 310 (or later).