3. Statements : OpenROAD SQL Statements : Savepoint Statement
 
Share this page                  
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;