ASA SQL Reference

SQL Statements

ROLLBACK statement

Description 

Use this statement to end a transaction and undo any changes made since the last COMMIT or ROLLBACK.

Syntax 

ROLLBACK [ WORK ]

Usage 

A transaction is the logical unit of work done on one database connection to a database between COMMIT or ROLLBACK statements. The ROLLBACK statement ends the current transaction and undoes all changes made to the database since the previous COMMIT or ROLLBACK.

Permissions 

None.

Side effects 

Closes all cursors not opened WITH HOLD.

See also 

• COMMIT statement
• ROLLBACK TO SAVEPOINT statement

Standards and compatibility 

• SQL/92    Entry-level feature.

• SQL/99    Core feature.

• Sybase    Supported by Adaptive Server Enterprise.

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