GET_SQL_LOCK_TIMEOUT¶

Applies to: SQLFlex

This command returns the number of milliseconds an SQL statement will wait for a database lock to be released. If the lock is not released before the timeout, then the statement will fail and an error will be raised. Note that the default value is -1, indicating that the statement will wait indefinitely.

Syntax

GET_SQL_LOCAL_TIMEOUT of {server} to {variable}

Parameter	Description
server	Name of the server
variable	Variable to hold the number of milliseconds

Example

GET_SQL_LOCK_TIMEOUT of "localhost" to iTimeout

SET_SQL_LOCK_TIMEOUT