DB2 graphic  QMF Version 8

Changing information in a query

You can change column names, change row conditions, and sort information in a query you have saved. You cannot change table names, but you can delete a table and specify a new one.

To change information in a query:

  1. Move the cursor to the information you want to change, and press the Change function key.

    The appropriate change panel, like the one in Figure 58, displays.

    Figure 58. QMF displays a panel where you specify changes to a query.
     PROMPTED QUERY     USERID.MYQUERY                    MODIFIED  LINE    1
                  +--------------------------------------------------------------+
       Tables:    |                        Change Column                         |
         Q.STAFF  |                                                              |
                  | Type a column name, expression (A+B, etc.), or a summary     |
       Columns:   | function (SUM, etc.).  You can use the following arithmetic  |
         NAME     | operators: add(+), subtract(-), multiply(*), and divide(/).  |
       > ...      |                                                              |
         JOB      | (                                                          ) |
                  | (                                                          ) |
       Row Condit | (                                                          ) |
         If JOB I | (                                                          ) |
                  | (                                                          ) |
       *** END ** +--------------------------------------------------------------+
                  | F1=Help  F4=List  F12=Cancel                                 |
                  +--------------------------------------------------------------+
     
     
  2. Enter the changes to the information.

The Prompted Query panel displays with the changed information in the echo area.


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