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.