COMMIT

The COMMIT statement ends a unit of work and commits the database changes that were made by that unit of work.  You can specify WORK or HOLD for the statement.  COMMIT WORK has the same effect as COMMIT.  COMMIT HOLD indicates a hold on resources.  If specified, all resources acquired during the unit of work are held.  Locks on specific rows and objects implicitly acquired during the unit of work are released. This statement does not affect commitment operations that are performed with COMMIT(*NONE) commitment control.

Example:

Commit all of the changes to the database made in the current unit of work.

COMMIT WORK

For more information, see COMMIT in the SQL Reference topic in the Information CenterLink to Information center.