ASA Database Administration Guide
  Database Options
    Alphabetical list of options

AUTO_COMMIT option [ISQL]

Function 

Controls whether a COMMIT is performed after each statement.

Allowed values 

ON, OFF

Default 

OFF

Description 

If AUTO_COMMIT is ON, a database COMMIT is performed after each successful statement. If the COMMIT fails, you have the option to execute additional SQL statements and perform the COMMIT again, or execute a ROLLBACK 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).