Icon COMMIT Statement

Introduction
The SQL COMMIT statement is used to commit an active transaction on the current database.

Syntax
COMMIT [WORK] [FLUSH]

Use the COMMIT statement to commit an active transaction. You may optionally include the WORK keyword for compatibility with the SQL standard.

FLUSH Clause
Use the FLUSH clause to indicate that the commit operation should also instruct the operating system to flush all committed data to disk.

Please see the Transactions topic for more information on transactions.
Image