SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-19
Using the CHECK Option
Interaction Between the CHECK Option and Other
SQLCOMP Options
Table 10-1 on page 10-20 describes the actions of the SQL executor when it runs an
SQL program compiled with a CHECK option and the RECOMPILE, NORECOMPILE,
RECOMPILEONDEMAND, or RECOMPILEALL option for this situation.
At SQL load time, the SQL executor detects invalid statements or statements that refer
to a DEFINE that has changed since the last explicit SQL compilation. (SQL load time
occurs when a program executes its first SQL statement.)