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.