Reference Guide > TDV SQL Script > SQL Script Statement Reference > COMMIT
 
COMMIT
The COMMIT statement in SQL Script is used to commit an independent transaction inside a compound statement.
Syntax
COMMIT
Remark
• It is illegal to call COMMIT in a compound statement that is not declared INDEPENDENT.
• For details, see Independent Transactions, Compensating Transactions, and Compound Statements.
Example
PROCEDURE p ( )
BEGIN INDEPENDENT TRANSACTION
  DECLARE my_exec EXCEPTION;
  INSERT INTO /shared/T (name, score) VALUES ('Joe', 123);
  COMMIT;
  RAISE my_exec;
END