SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-65
Statement Recompilation
If you issue a CONTROL TABLE statement for the SIMILARITY_CHECK option, the
specified control table value overrides the system-defined default setting. See
CONTROL TABLE Statement on page 2-46.
For more information about late name resolution, similarity checks, and automatic
recompilation, see the SQL/MX Programming Manual for C and COBOL.
INTERACTIVE_ACCESS Set to ON or OFF. If set to ON, the compiler selects the
most appropriate index-based access plan. If OFF, the
compiler follows normal behavior and does not
emphasize index-based access plans.
The default is OFF.
RECOMPILATION_
WARNINGS
Set to ON or OFF. If set to ON, when a statement is
automatically recompiled in an application (because of
various factors), NonStop SQL/MX returns a warning
message. A warning is also returned when a similarity
check passes. Set this default to ON only to direct
warning messages to an application when automatic
recompilation take place or to notify it if a similarity check
has passed. When automatic recompilation occurs,
NonStop SQL/MX always logs an EMS event regardless
of the setting of this CQD.
The default is OFF.
SIMILARITY_CHECK Set to ON or OFF. If set to ON, NonStop SQL/MX
compares whether two tables used in an SQL statement
(the previous compile-time table and the new run-time
table) are sufficiently similar so that the previous access
plan can be used for the new table. If OFF, NonStop
SQL/MX automatically recompiles the statement,
depending on the outcome of late name resolution,
timestamp comparison, or table redefinition.
The default is ON.
Attribute Setting