DB2 graphic  QMF Version 8

Confirmation panels

If there is a CONFIRM parameter on a command, you can specify YES or NO (or use the default in your profile). If the command would modify the database and the CONFIRM parameter is YES, a confirmation panel like the one below is displayed:

                       RUN CONFIRMATION
 
WARNING:
Your RUN command will modify this number of rows in the
database:         1
 
Do you want to make this change?
1 1. YES - Make the changes permanent in the database.
  2. NO  - Restore the table to what it was before the query
     was run; make no changes.

Many QMF confirmation panels for changes to the database are actually prompting you to do a commit (by entering YES to keep the changes) or a rollback (by entering NO).

Because the changes were already made to the database, the database manager holds locks on the data until you reply YES or NO on the confirmation panel.

If you are using DB2 Server for VM or VSE, the tables you are working with might be in a nonrecoverable dbspace. If so, any changes you make are committed to the database immediately; you cannot execute a rollback. Therefore, if a table is in a nonrecoverable dbspace, specifying NO on the confirmation panel will not prevent the changes from taking place.

For more information on dbspace, contact your database administrator or see the DB2 Server for VM System Administration guide.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004