User's Guide

Part II. Tutorials

Chapter 10. Updating the Database

The SQL statement

     COMMIT

makes all changes permanent.

Use COMMIT with care When trying the examples in this tutorial, be careful not to COMMIT any changes until you are sure that you want to change the database permanently.

Making changes permanent in ISQL

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".

ISQL has another option, named AUTO_COMMIT. If this option is on, ISQL does a COMMIT operation after every command. The default for this option is OFF. Usually you will want it OFF, giving you the opportunity to ROLLBACK the changes (if, for example, an update or delete operation doesn't produce the intended results).