SET_SQL_LOCK_TIMEOUT¶
Applies to: SQLFlex
This command is used to set the number of milliseconds an SQL statement waits for a database lock to be released before timing out. Locks are used with transactions to maintain atomicity. If a lock is not released before the timeout, then the statement will fail and an error will be raised. By default, the timeout is set to -1, indicating that statements will wait indefinitely before timing out.
Syntax
SET_SQL_LOCAL_TIMEOUT of {server} to {variable}
Parameter |
Description |
|---|---|
server |
Name of the server |
variable |
Number of milliseconds to wait until timeout |
Example
SET_SQL_LOCK_TIMEOUT of "localhost" to 6000