AUTO_COMMIT option [DBISQL]

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. 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).

AUTO_COMMIT basically performs the same function as CHAINED, except that AUTO_COMMIT only takes effect if you are running DBISQL.