Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Transaction Statements >

COMMIT statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

COMMIT statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Transaction Statements

Commit a transaction.

 

Syntax

 

<commit statement> ::= COMMIT [ WORK ]

 

 

Usage

 

The COMMIT statement terminates the active transaction and makes all changes made during the transaction permanent in the database.

 

 

Notes

 

§

The COMMIT statement will return an error if no transaction is active.

 

 

Examples

 

1)

The following example commits the current transaction:

 

      COMMIT;

 

 


Conformance

 

SQL:2003 standard

-

Core SQL

 

© Nexus Database Systems Pty Ltd.

nexus_logo