Syntax documentation AUTOCOMMIT Command Locate the document in its SAP Library structure

You use this command for setting up a Structure linkdatabase session to activate/deactivate AUTOCOMMIT mode for a database session.

Syntax

<autocommit_statement> :: = AUTOCOMMIT ON | AUTOCOMMIT OFF

AUTOCOMMIT ON

The AUTOCOMMIT mode is activated (SAP DB Loader default value).

With commands for loading data, a Structure linkCOMMIT is used to complete the insertion of a certain number of data records. The user can determine this number using the SET TRANSACTION SIZE command. This mode is not relevant when data is unloaded, because the table contents in the database are not modified.

If you execute COMMIT and ROLLBACK statements when AUTOCOMMIT mode is activated, the SAP DB Loader ignores these statements.

Each SQL statement is terminated implicitly with a COMMIT by the SAP DB Loader.

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 at once.

This mode does not apply to the commands FASTLOAD, TABLEEXTRACT, and TABLELOAD, as these commands run outside the transaction concept of the database and are therefore always implicitly terminated with a COMMIT by the SAP DB Loader.

Note

Large transactions (such as a large number of data records to be loaded) require a correspondingly large Structure linklog area.