Commit and Rollback

A commit terminates the current transaction normally. A rollback undoes all the changes to the data source initiated by the current transaction. Both commands remove all prepared SQL requests from the environment.

COMMIT

Terminates the current transaction normally.

commit-statement ::= COMMIT WORK

Example: Terminating the Current Transaction Normally

COMMIT WORK

ROLLBACK

Undoes all the changes to the data source initiated by the current transaction.

rollback-statement ::= ROLLBACK WORK

Example: Undoing Changes

ROLLBACK WORK