Use this statement to establish a savepoint within the current transaction.
SAVEPOINT [ savepoint-name ]
Establish a savepoint within the current transaction. The savepoint-name is an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement. All savepoints are automatically released when a transaction ends. See Savepoints within transactions.
Savepoints that are established while a trigger or atomic compound statement is executing are automatically released when the atomic operation ends.
You cannot modify data in a proxy table from within a savepoint.
SQL/2003 SQL/foundation feature outside core SQL.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|