Library /sys$common/syshlp/SQL$HELP72.HLB  —  ROLLBACK
    Ends a transaction and undoes all changes you made since that
    transaction began. The ROLLBACK statement also:

    o  Closes all open cursors (with the exception of WITH HOLD
       cursors)

    o  Releases all row locks

    o  Performs a checkpoint operation if fast commit processing is
       enabled

    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, RENAME, GRANT, and REVOKE)
Additional Information: explode extract
Environment Format Arguments Examples
Close Help