Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

on_tsql_error option [compatibility] Next Page

optimistic_wait_for_commit option [compatibility]


Controls locking behavior for the wait_for_commit option.

Allowed values

On, Off

Default

Off

Remarks

By default, optimistic_wait_for_commit is Off.

Locking behavior is changed as follows when both optimistic_wait_for_commit and wait_for_commit are On:

This feature is for use in migrating version 5.x.x applications to version 8.0.x or later by mimicking version 5.x.x locking behavior when transactions add foreign rows before primary rows (as long as no two transactions concurrently add foreign rows with the same key value).

Note that this option is not recommended for general use as there are a number of situations in which transactions would not be allowed to commit, including:

See also