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