ASA SQL Reference

SQL Statements

SAVEPOINT statement

Description 

Use this statement to establish a savepoint within the current transaction.

Syntax 

SAVEPOINT [ savepoint-name ]

Usage 

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.

Permissions 

None.

Side effects 

None.

See also 

• RELEASE SAVEPOINT statement
• ROLLBACK TO SAVEPOINT statement

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    SQL/foundation feature outside of core SQL.

• Sybase    Not supported in Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, you can use the SAVE TRANSACTION statement.

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.