Use the threshold to set the length of time, in milliseconds, a
transaction waits to obtain a lock. If the transaction attempting to obtain a lock conflicts
with another transaction's existing lock, it waits until the BLOCKING_TIMEOUT option threshold is reached. If the conflict still exists, the
transaction rolls back and you see an error.
Prerequisites
SAP Sybase IQ server has a simplex
database.
Task
Note: The default value, 0, indicates that a blocked transaction must wait indefinitely
until all conflicting transactions release their locks.
Set the BLOCKING_TIMEOUT
database option value to the number of milliseconds you want the transaction to wait
for conflicting transactions to release their locks.
set temporary option blocking_timeout = '400';
Note: The blocking option can be set either at the connection or
PUBLIC level.