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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-215
SET TABLE TIMEOUT Statement
TIMEOUT value
specifies that value is for a lock timeout. If value elapses before a DML
statement can acquire a lock on a table, the statement fails, and NonStop SQL/MX
returns file-system error 73 (disk file or record is locked).
The value overrides any compiled values, such as those previously set by a
CONTROL TABLE statement with the TIMEOUT option.
STREAM TIMEOUT value
specifies that value is for a stream timeout. A query that tries to access an empty
stream waits until value elapses before NonStop SQL/MX returns:
*** ERROR[8006] The stream timed out, but the cursor is still
open.
The value overrides any compiled values, such as those previously set by a
CONTROL QUERY DEFAULT statement with the STREAM_TIMEOUT option.
value
specifies the timeout value in hundredths of seconds.
Specify value as a:
•
Numeric value (for example, 3000)
•
String with single quotation marks (for example, '-1')
•
Host variable in an embedded SQL statement
•
Parameter
The range is between -1 and 2147483519, expressed in hundredths of seconds.
The value -1 represents an infinite timeout and directs NonStop SQL/MX not to
time out.
A value of zero (0) directs NonStop SQL/MX not to wait. If a table lock cannot be
acquired or if a stream is empty, NonStop SQL/MX immediately times out.
RESET
removes the dynamic timeout value (if set) for the specified table, resetting the
timeout value to the static values set during explicit SQL/MX compilations. The
RESET option with an asterisk resets the dynamic timeout value (lock or stream
timeout, as specified) for all tables. The RESET option for a specific table does not
override a dynamic timeout value that was set for all tables. (See MXCI Examples
of SET TABLE TIMEOUT on page 2-216.)
Note. Because of overhead processing by NonStop SQL/MX after a timeout occurs on a
locked table, the actual time is usually a few seconds longer than value.
Embed
MXCI