You can use the Loader command AUTOCOMMIT to set up a database session that activates/deactivates AUTOCOMMIT mode for a database session. If the AUTOCOMMIT command is not used, AUTOCOMMIT mode is implicitly activated.
Syntax
<autocommit_command> ::=
AUTOCOMMIT ON
| AUTOCOMMIT OFF
The AUTOCOMMIT mode is activated (Loader default value). Loader terminates each SQL statement implicitly with a COMMIT. If you execute COMMIT and ROLLBACK statements while AUTOCOMMIT mode is activated, Loader ignores these statements.
With commands for importing data, a COMMIT is used to complete the insertion of a certain number of data records. The user can define this number using the SET TRANSACTION SIZE command. This mode is not relevant when data is exported since the table contents in the database are not modified.
AUTOCOMMIT mode is deactivated. All transactions must be terminated explicitly using a COMMIT. You can group commands in units so that they can be completed or reset together. This mode is not valid for commands that are not processed as part of the transaction concept of the database and that are therefore always implicitly completed with COMMIT.
Note
Large transactions (such as those involving a large number of data records to be loaded) require a correspondingly large log area.