COMMIT statement

Wed, 03/04/2009 - 20:02 |  hdanzl

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
‹ START TRANSACTION statementupROLLBACK statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Transaction Statements

Powered by Drupal and Drupal Theme created with Artisteer.