ROLLBACK

If you are inside a compound statement with an independent transaction, you can invoke ROLLBACK in SQL Script to roll back the transaction. See Compound Statements.

Syntax

ROLLBACK

Remark

It is illegal to call ROLLBACK in a compound statement that is not declared INDEPENDENT.

Example

PROCEDURE p ( )

BEGIN INDEPENDET TRANSACTION

  INSERT INTO /shared/T (name, score) VALUES ('Joe', 123);

  ROLLBACK;

END