SET STATEMENT MAXTIME
SET STATEMENT MAXTIME minutes
Access requirements
Database user
Usage
Use the SET STATEMENT MAXTIME statement to set connection-specific maximum execution time in minutes.
The SET STATEMENT MAXTIME statement takes effect immediately, starting from the next SQL statement, and is effective until a new maximum time is set.
Parameters, clauses, keywords, and variables
▪ minutes: Maximum number of minutes to wait for a statement to execute. The default value of 0 means there is no maximum time.
Example
SET STATEMENT MAXTIME 180;
Go up to