The AUTOCOMMIT mode determines the COMMIT behaviour for SQL statements.
There are two settings for the AUTOCOMMIT mode:
· Switched on: SQL statements are completed automatically with a COMMIT.
· Switched off: To execute an SQL statement, a COMMIT must be entered explicitly.
You can also change the AUTOCOMMIT mode for some database tools and interfaces.
See also:
Loader, AUTOCOMMIT Command
SQLCLI, Overview of the SQLCLI Commands
JDBC Manual, Specifying Other Connection Options
Python Manual, connect Method