SET AUTOCOMMIT is an executable XDB Server utility command that can be issued interactively or embedded in a host language. SET AUTOCOMMIT can be dynamically prepared.
No special authorization is required to set autocommit on or off.
SET AUTOCOMMIT {ON | OFF}
The command to turn autocommit on is:
SET AUTOCOMMIT ON
To turn autocommit off:
SET AUTOCOMMIT OFF
Description
You can use autocommit to automatically commit a command as soon as it is successfully executed. If autocommit is on, an implicit COMMIT is issued at command completion or the close of a cursor (for SELECT statements). If Backward Logging is turned on, the autocommit feature causes the contents of the Backward Log to be cleared after each transaction. However, the release of resources such as locks and cursors occurs independently of Backward Logging.