ROLLBACK [ WORK ]

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.

None.

Closes all cursors not opened WITH HOLD.

• COMMIT statement
• Keyboard shortcuts for Interactive SQL
• ROLLBACK TO SAVEPOINT statement
• Interactive SQL options
• Cancellation of changes