RDB/VMS SQL ROLLBACK — VMS RDB_3.1A
ROLLBACK WORK ;
Additional information available:
More Information
The ROLLBACK statement ends a transaction and undoes all changes
that have been made to the database since that transaction
began. The ROLLBACK statement also:
o Closes all open cursors
o Releases all locks
The ROLLBACK statement affects:
o All open databases included in the current transaction
o All changes to data made with SQL data manipulation
statements (DELETE, UPDATE, and INSERT)
o All changes to data definitions made with SQL data
definition statements (ALTER, CREATE, DROP, GRANT, REVOKE
and COMMENT ON)
WORK
An optional keyword that has no effect on the ROLLBACK statement.