Background documentationAUTOCOMMIT Command Locate this document in the navigation structure

 

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.

Structure

Syntax Syntax

  1. <autocommit_command> ::=
      AUTOCOMMIT ON 
    | AUTOCOMMIT OFF
End of the code.
AUTOCOMMIT ON

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 OFF

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 Note

Large transactions (such as those involving a large number of data records to be loaded) require a correspondingly large log area.

End of the note.