SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Interactive SQL options

auto_commit option [Interactive SQL]

Controls whether a COMMIT is performed after each statement.

On, Off

Off

If auto_commit is On, a database COMMIT is performed after each successful statement.

By default, a COMMIT or ROLLBACK is performed only when the user issues a COMMIT or ROLLBACK statement or a SQL statement that causes an automatic commit (such as the CREATE TABLE statement).

• SET OPTION statement [Interactive SQL]