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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-50
Considerations for CONTROL TABLE
error. This option is for static operations only. For dynamic operations, see SET
TABLE TIMEOUT Statement on page 2-218.
'timeout-value'
specifies the time in hundredths of seconds. The range of values is from -1 to
2147483519, expressed in hundredths of seconds. The value -1 directs
NonStop SQL/MX not to time out. The value 0 directs NonStop SQL/MX not to
wait for a table lock. If the lock cannot be acquired, NonStop SQL/MX
immediately returns an error.
SIMILARITY_CHECK {'ON'|'OFF'}
specifies whether to perform similarity checks for a new and previous table to avoid
statement recompilation or always recompile at run time, depending on the
outcome of various factors. This option applies only to tables (not views).
ON
directs NonStop SQL/MX to perform similarity checks at run time to determine
whether the new table is similar to the previous table. If the tables are similar,
NonStop SQL/MX uses the new table without statement recompilation.
Otherwise, the SQL statement is recompiled with the new table name. The
default is ON.
OFF
directs NonStop SQL/MX to recompile an SQL statement at run time,
depending on the outcome of late name resolution, timestamp comparison, or
table redefinition.
In MXCI, you can change a table in a prepared statement by using DEFINE
commands. See ADD DEFINE Command on page 4-3 and ALTER DEFINE
Command on page 4-5.
For more information about similarity checks, see the SQL/MX Programming
Manual for C and COBOL or the SQL/MX Programming Manual for Java.
RESET
cancels all previously set control options for the specified table or view, and
NonStop SQL/MX uses only the default control values.
Considerations for CONTROL TABLE
Scope of CONTROL TABLE
The result of the execution of a CONTROL TABLE statement stays in effect until the
current process terminates or until the execution of another CONTROL TABLE
statement for the same control-table-option overrides it. For a detailed list of
the precedence of default settings, see System Defaults Table on page 10-29.