Disable connection blocking to force any transaction attempting to obtain a lock
that conflicts with another transaction's existing lock to roll back the transaction and
display an error.
Prerequisites
SAP Sybase IQ server has a simplex database.
Task
Set the BLOCKING database option
to OFF.
set temporary option blocking = 'Off';
Note: The blocking option can be set either at the connection or PUBLIC
level.