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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

auto_commit_on_create_local_temp_index option

Controls whether the database server performs a COMMIT before an index is created on a local temporary table.

Allowed values

On, Off

Default

On

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

When this option is set to On, the database server executes a COMMIT before an index is created on a local temporary table. If the commit fails, the operation fails or rolls back. When this option is set to Off (the default), a COMMIT is not performed, which allows a procedure that relies on the index to be used as part of an atomic operation (such as a trigger, UPDATE statement, INSERT statement, DELETE statement, or the FROM clause).