autocommit
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.
- Warning
- If
autocommitis enabled, changes to the database cannot be rolled back.
- Default Value
If the autocommit option is not defined, the default value of OFF is used.
- Example
-
autocommit=OFF
- SQL Options
This option key is associated with the SQL Connection Handle and can be set or retrieved using:
- See also
- SQL SET statements
- SQLSetConnectAttr()
- SQLGetConnectAttr()
- Note
- SQL options can also be associated with the RDM_DB handle along with the Database Configuration Options.
- Boolean Values Accepted
The following values can be accepted boolean values:
| TRUE Values | FALSE Values |
|---|---|
| 1 | 0 |
| On | Off |
| True | False |