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