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
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 |