User's Guide

Part II. Tutorials

Chapter 10. Updating the Database

You may be a little concerned about all of the changes you have made to the employee table. However, SQL allows you to undo all of these changes with one command:

     ROLLBACK

The ROLLBACK statement

The ROLLBACK statement undoes all changes you have made to the database since the last time you made changes permanent (see COMMIT in the next section).

The default action in ISQL is to do a COMMIT on exit. This can be controlled with the ISQL option COMMIT_ON_EXIT.

For more information on ISQL options, see "SET OPTION statement".