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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-214
SET TABLE TIMEOUT Statement
SET TABLE TIMEOUT Statement
Considerations for SET TABLE TIMEOUT
MXCI Examples of SET TABLE TIMEOUT
C Examples of SET TABLE TIMEOUT
The SET TABLE TIMEOUT statement sets a dynamic timeout value for a lock timeout
or a stream timeout in the environment of the current session. The dynamic timeout
value overrides the compiled static timeout value in the execution of subsequent DML
statements.
You can use SET TABLE TIMEOUT from MXCI or in embedded SQL programs.
SET TABLE TIMEOUT is an SQL/MX extension.
TABLE { * | table }
specifies the name of the table. The table must exist in the user catalog before this
statement is executed.
table can be any of:
•
Guardian physical name of the form
[\node.][[$vol.]subvol.]filename
•
Three-part logical name of the form [[catalog.]schema.]table
•
DEFINE name such as =CUSTOMER
•
Host variable (If you use a host variable, you do not need to provide a
PROTOTYPE clause.)
An asterisk (*) specifies all tables accessed in the current session. This option
clears all previous dynamic timeout settings for specific tables in the current
session.
If the table or DEFINE does not exist during explicit SQL/MX compilation, SET
TABLE TIMEOUT returns an error. You must recompile the program if it has a
missing table or DEFINE. For more information, see the SQL/MX Programming
Manual for C and COBOL.
To set the lock timeout
SET TABLE { * | table } TIMEOUT { value | RESET }
To set the stream timeout
SET TABLE * STREAM TIMEOUT { value | RESET }
Note. The table option is supported only for the lock timeout option. For the stream
timeout option, you must use the asterisk (*) option.
Embed