ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 549
SQL Statements S - Z
SET USER TIMEOUT
• The TimeoutValue may not exceed the maximum timeout value set by the database
administrator.
• The database administrator may specify the maximum and default timeout values with
the SQLUtil ALTDBE command, or with the following SQL statements:
• START DBE
• START DBE NEW
• START DBE NEWLOG
• You may view the current maximum and default timeout values with the SQLUtil
SHOWDBE command.
• The SET USER TIMEOUT statement is not allowed in the PREPARE statement. A host
variable is not permitted if the SET USER TIMEOUT statement is used in the EXECUTE
IMMEDIATE statement. No section is created for the SET USER TIMEOUT statement.
• An active transaction is not required to execute a SET USER TIMEOUT statement. An
automatic transaction is not started when a SET USER TIMEOUT statement is executed.
Authorization
You do not need authorization to use SET USER TIMEOUT.
Example
Examples of setting the user timeout value in seconds:
SET USER TIMEOUT TO 10
SET USER TIMEOUT TO 5 SECONDS
Set user timeout in minutes:
SET USER TIMEOUT 1 MINUTES
When setting the user timeout value to 0, the user will not wait for a database resource
that is unavailable, such as a lock.
SET USER TIMEOUT 0
Set the user timeout value to the default or the maximum value.
SET USER TIMEOUT DEFAULT
SET USER TIMEOUT MAXIMUM