SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-63
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-48.
For more information about late name resolution, similarity checks, and automatic
recompilation, see the SQL/MX Programming Manual for C and COBOL or the
SQL/MX Programming Manual for Java.
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
recompilations 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