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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-48
CONTROL TABLE Statement
error. This option is for static operations only. For dynamic operations, see SET
TABLE TIMEOUT Statement on page 2-214.
'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.
RESET
cancels all previously set control options for the specified table or view, and
NonStop SQL/MX uses only the default control values.