<detectlock>
The detectlock option indicates whether to return an error trying to retrieve a record locked by another user if the READ operation does not have an explicit WITH LOCK option. This feature is turned off by default.
Accepted Values
Value
Effect
Synonyms
yes
the record locked error is returned
y, true, on, 1
no
the record locked error is not returned
n, false, off, 0
Example
<detectlock>yes</detectlock>