Enables or disables autocommit
mode of operation for the database connection. Every individual database interaction (i.e., each insert, update, delete statement or each dynamic DDL statement) submitted with autocommit
enabled will be executed in its own transaction that is implicitly committed.
autocommit
is enabled, changes to the database cannot be rolled back.If the autocommit
option is not defined, the default value of OFF
is used.
This option key is associated with the SQL Connection Handle and can be set or retrieved using:
The following values can be accepted boolean values:
TRUE Values | FALSE Values |
---|---|
1 | 0 |
On | Off |
True | False |