Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

WORK

More Information

RDB/VMS SQL ROLLBACK — VMS SQLdev_2.0

 ROLLBACK WORK ;

Additional information available:

WORK

More Information

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026