Switches batch mode on or off. In this mode, SQL statements are not immediately executed but bundled, this can increase the execution speed.
|BEGIN||Switches to batch mode. From this point all entered SQL statements are saved and only executed after BATCH END has been entered.|
|CLEAR||Deletes all stored statements.|
|END||Runs all SQL statements entered since the last BATCH BEGIN and exits batch mode.|
If autocommit is on and an exception is raised for any statements in batch mode, the statements are not executed and the transaction is rolled back to the beginning of the batch. However, if the COMMIT statement is used, the transaction is processed and the changes are saved.
If EXAplus is in batch mode, only specific statements are accepted:
- SQL Statements (see SQL Reference section) except scripts
- DEFINE and UNDEFINE
- START, @, and @@