Skip to main content

COMMIT (bSQL) | Blockpoint Docs

Finalizes all changes made in a batched transaction.

bSQL Syntax Conventions.

Syntax

COMMIT

General Remarks

  • The COMMIT statement is used in conjunction with a START TRANSACTION statement.
  • Non-atomic mutations aren't committed until the COMMIT command is called.
  • When the COMMIT command is called, the changes made to the in-memory blockchain are written to disk and can't be rolled back.
  • Committing a batched transaction increment the transaction count by 1.

Examples

A. Committing a non-atomic mutation.

This example uses the Financial Demo Database and commits the non-atomic insertion into companies.

START TRANSACTION
SET AUTOCOMMIT = 0
INSERT financial.companies VALUES 
("MYL", "Mylan", "Health Care")
COMMIT

See Also