SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-20
Using the CHECK Option
Table 10-1. Behavior of the SQL Executor for an Invalid Statement or a Changed
DEFINE Detected at SQL Load Time (page 1 of 2)
SQLCOMP Options Behavior
CHECK INVALID PROGRAM Option
RECOMPILE RECOMPILEALL The SQL executor recompiles (in
memory) all SQL statements. This
option is the default behavior.
RECOMPILE RECOMPILEONDEMAND The SQL executor recompiles
(in memory) a statement the first time it
is executed using Guardian names and
DEFINE names as follows:
•
Uses names at SQL load-time if
execution-time name resolution is
not enabled
•
Uses names at statement
execution time if execution-time
name resolution is enabled
NORECOMPILE RECOMPILEALL or
RECOMPILEONDEMAND
The SQL executor returns an error to
the program.
CHECK INVALID PLANS Option
RECOMPILE RECOMPILEALL The SQL executor recompiles (in
memory) only invalid SQL statements
and statements that refer to changed
DEFINEs.
The SQL executor executes other
statements using existing plans.
RECOMPILE RECOMPILEONDEMAND The SQL executor recompiles (in
memory) the statement the first time it
is executed using Guardian names and
DEFINE names as follows:
•
Uses names at SQL load time if
execution-time name resolution is
not enabled
•
Uses names at statement
execution time if execution-time
name resolution is enabled
The SQL executor executes other
statements using existing plans from
the program file
NORECOMPILE RECOMPILEALL or
RECOMPILEONDEMAND
The SQL executor returns an error to
the program.