Savepoint Statement
The savepoint statement declares a named savepoint marker within a transaction. Savepoints can be used in conjunction with the
rollback statement (see
Rollback Statement) to roll back a transaction to the specified savepoint when necessary. Using savepoints can eliminate the need to roll back an entire transaction if it is not necessary.
Note: This statement has additional considerations when used in a distributed environment. For more information, see the Ingres Star User Guide.
This statement has the following syntax:
savepoint savepoint_name;