Collection Contents Index REVOKE statement ROLLBACK TO SAVEPOINT statement pdf/chap9.pdf

Reference Manual
   CHAPTER 9. SQL Statements     

ROLLBACK statement


Function 

To undo any changes made since the last COMMIT or ROLLBACK.

Syntax 

ROLLBACK [ WORK ]

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.

Standards and compatibility 


Collection Contents Index REVOKE statement ROLLBACK TO SAVEPOINT statement pdf/chap9.pdf