SAVEPOINT
The SAVEPOINT statement is used to identify a point in a transaction to which you can later roll back.
General format
EXEC SQL [ AT Database ]
 
  SAVEPOINT Savepoint-Name
 
END-EXEC
Syntax rules
1. Savepoint-Name is Nonnumeric Literals, as defined in the Definitions section of the Preface of this document.
General rules
1. Savepoint names must be distinct within a given transaction. If you create a second savepoint with the same identifier as a previous savepoint, then the previous savepoint is erased.
Examples
Define a savepoint named SP1
exec sql
     savepoint sp1
end-exec