User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To undo any changes made since the last commit or rollback.

Syntax

     ROLLBACK [ WORK ]

Usage

Anywhere.

Permissions

Must be connected to the database.

Side effects

Closes all cursors not opened WITH HOLD.

See also

• COMMIT statement
• ROLLBACK TO SAVEPOINT statement

Description

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