8. SQL Statements : SAVEPOINT
 
Share this page                  
SAVEPOINT
Valid in: SQL, ESQL, OpenAPI, JDBC
The SAVEPOINT statement declares a named savepoint marker within a transaction. Savepoints can be used in conjunction with the 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.