DTRHELP.HLB  —  Commands Statements Clauses, ROLLBACK Statement
       Undoes all the changes you made to the database since the last
       COMMIT or ROLLBACK statement, or since your first READY if you
       have not done a ROLLBACK or a COMMIT. The ROLLBACK statement
       performs a Oracle CODASYL DBMS or relational rollback and
       releases all collections associated with Oracle CODASYL DBMS
       domains and records and with relational domains and relations.
       ROLLBACK then readies Oracle CODASYL DBMS realms again or
       finishes and starts a new relational source transaction.

       The ROLLBACK statement also acts as an ABORT in procedures,
       nested statements, and command files.

       The ROLLBACK statement affects all readied parts of Oracle
       CODASYL DBMS and relational databases, whether or not you made
       any changes to the data they contain. Domains based on RMS files
       are not affected by the ROLLBACK statement.

       Format

         ROLLBACK

1  –  Example

       The following example for the Oracle CODASYL DBMS database
       PARTS_DB connects an employee named Hill to a part LA36 in the
       RESPONSIBLE_FOR set. The ROLLBACK statement undoes the change:

       DTR> FIND E IN EMPLOYEES WITH EMP_LAST_NAME = "HILL"
       DTR> SELECT 1
       DTR> FOR P IN PART WITH PART_DESC = "LA36"
       CON>     CONNECT P TO E.RESPONSIBLE_FOR
       DTR>  ROLLBACK
       DTR>
Close Help