DB2 graphic  QMF Version 8

Adding rows

To add rows to a table using the Table Editor:

  1. Do one of the following tasks, depending on where you are starting: For example, to add rows to the PERS table from the QMF Home panel, type PERS (MODE=ADD, and press the Edit Table key.

    To enter the same command and save each addition as you make it, enter:

    PERS (MODE=ADD SAVE=IMMEDIATE

    The Table Editor ADD panel displays, showing the name of each column in the table, followed by an entry field where you enter new data for that column.

    Figure 173. The Table Editor ADD panel
     ADD                  USERID.PERS
     
                                                                       1 to 7 of 7
     ACCTNO. . . . . . . . (_-______)
     COMPANY . . . . . . . (_+_________________________)
     STREET. . . . . . . . (_-____________________)
     CITY. . . . . . . . . (_-____________________)
     STATE . . . . . . . . (_-__)
     ZIP . . . . . . . . . (_-______)
     DATE  . . . . . . . . (_+______)
     NOTES . . . . . . . . (_+_________________________________________________>
    On this panel:

    To move a specific column to the top of the panel, type its number in the first position of the scroll indicator. Press the Forward key to see the rest of the columns. Table Editor panels do not have a command line, so press the appropriate function key for the command you want to issue.

    You can display the default settings for the fields by using the Show Field PF key. This is helpful if you have typed over the original values and forgotten what they were.

  2. Type the information in each field as it appears in Figure 174.

    Use the Tab key to move from field to field.

    If you need to know what values are valid for a field, press the Show Field function key.

    Figure 174. Type data for your table in the fields on the panel.
     ADD                  USERID.PERS
     
                                                                       1 to 7 of 7
     ACCTNO. . . . . . . . (_15002__)
     COMPANY . . . . . . . (_S & J Supply Co.__________)
     STREET. . . . . . . . (_948 C Street_________)
     CITY. . . . . . . . . (_Boston_______________)
     STATE . . . . . . . . (_MA_)
     ZIP . . . . . . . . . (_06000__)
     DATE  . . . . . . . . (_19970314_)
     NOTES . . . . . . . . (_+__________________________________________________>
     
     
     
  3. Press the Add function key after entering all the data for the row.

If you specified that you want to save each row when you press the Add function key (SAVE=IMMEDIATE), QMF adds the new row to the table.

If you specified that you want to hold all the rows and save them when you end the Table Editor session (SAVE=END), the new row is held temporarily until you end the Table Editor session.

The Table Editor ADD panel is reset as is shown in Figure 173.


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