Using QMF

Adding the rows

To add rows to a table using the Table Editor:

1. Do one of the following, depending on where you are starting:
   • From the QMF Home panel, type:

     tablename (MODE=ADD
     

     Then, press the Edit Table function key.

   • From any other QMF panel with a command line, enter:

     EDIT TABLE tablename (MODE=ADD
     

   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 165. The Table Editor ADD panel
   

   +--------------------------------------------------------------------------------+
   | ADD                  USERID.PERS                                               |
   |                                                                                |
   |                                                                   1 to 7 of 7  |
   | ACCTNO. . . . . . . . (_-______)                                               |
   | COMPANY . . . . . . . (_+_________________________)                            |
   | STREET. . . . . . . . (_-____________________)                                 |
   | CITY. . . . . . . . . (_-____________________)                                 |
   | STATE . . . . . . . . (_-__)                                                   |
   | ZIP . . . . . . . . . (_-______)                                               |
   | DATE  . . . . . . . . (_+______)                                               |
   | NOTES . . . . . . . . (_+_________________________________________________>    |
   +--------------------------------------------------------------------------------+

   On this panel:

   • The name of the table you are editing and the user ID of the table owner appears at the top of the panel.
   • The columns displayed on this panel make up one row in the table.
   • A null indicator (not the same as zero or blank) or a column default indicator (if available for the column) is displayed in each field to indicate that nothing has been entered. These indicators are configurable. See Specifying column default and null for more information.

     A blank or a zero means that a blank or zero value has been entered for that column.

   • The scroll indicator tells you how many columns are in a row, and how many columns appear on the 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 166.

   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 166. 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 165.