Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Index term
secondarycommit/rollback
primarytransaction
With Auto Commit enabled, all changes you make to the database data is automatically committed after the successful execution of an SQL statement. Auto Commit is enabled for a connection by default. You can change the default in the Options area of the Object View tab for the connection.  Note that this change can only by be done when the connection is disconnected.

...

Note

Not all databases supports transactions and thus always commits executions

Alternatively, you can use this command in a script to set it:

...