SET AUTOCOMMIT

Syntax

SET AUTOCOMMIT ON|OFF|EXIT;

Description

Controls whether Exasol should automatically perform COMMIT statements.

Command Description
ON After each SQL statement a COMMIT statement is executed automatically. This is preset by default.
OFF Automatic COMMIT statements are not executed.
EXIT A COMMIT statement is executed when EXAplus is exited.

- The recommended setting for normal applications is "ON". For additional information, refer to the Transaction Management section.
- If EXAplus is stopped with CTRL-C, an automatic COMMIT statement is not executed.

Example

set autocommit off;