SET AUTOCOMMIT ON|OFF|EXIT;
Controls whether Exasol should automatically perform COMMIT statements.
|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.