COMMIT (bSQL) | Blockpoint Docs
Finalizes all changes made in a batched transaction.
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