rollback_on_deadlock

Controls how transactions are treated when a deadlock occurs.

When this option is set to On, a transaction is automatically rolled back if it encounters a deadlock. The rollback happens after the current request completes. If this option is set to Off, SQL Anywhere automatically rolls back the statement that encountered the deadlock, and returns an error to that transaction indicating which form of deadlock occurred. Note that rolling back the statement likely would not release any of the locks acquired by the statement.

rollback_on_deadlock

Allowed values

Default

Scope

Remarks

See also