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
