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