commit

Syntax

COMMIT

Description

Issues a java.sql.Connection.commit request. Use this command only if auto-commit is off. A java.sql.Connection.commit request commits the currently active transaction and initiates a new transaction.

Example

snappy> AUTOCOMMIT off;
snappy> INSERT INTO greetings values (DEFAULT, 'hello');
1 row inserted/updated/deleted
snappy> COMMIT;