Function

The COMMIT statement terminates a transaction and makes permanent all changes that were made to the database during the terminated transaction.

 

Syntax

 

Description

The COMMIT statement terminates the current transaction and starts a new transaction. All changes to the database that have been made during the terminated transaction are made permanent. All cursors that have been opened during the current transaction are closed.

 

ANSI Specifics

The keyword WORK is mandatory.

 

CONNX Specifics

 

Example

The following example commits all changes made to the database in the current transaction.

 

COMMIT WORK;