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 autocommit is 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

String values above are not case-sensitive.