Data Manipulation Language Statements › @COMMIT—commits changes made to the database

@COMMIT—commits changes made to the database

The @COMMIT statement commits changes made to the database by an individual run unit. @COMMIT simulates an @FINISH-@BIND-@READY sequence without relinquishing control of database resources.

If the run unit is sharing its transaction with another database session, the run unit's changes may not be committed at the time the @COMMIT statement is executed.

Note: For more information about the impact of transaction sharing, see the Navigational DML Programming Guide.

Currency

Specifying @COMMIT ALL sets all currencies to null.