Using QMF

Selecting the rows to display

The Table Editor SEARCH panel shows the name of each column in the table, followed by an entry field where you can enter search criteria to select the rows you want to change.

Figure 169. The Table Editor SEARCH panel

+--------------------------------------------------------------------------------+
| SEARCH               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  . . . . . . . . (_-_______)                                              |
| NOTES . . . . . . . . (_-__________________________________________________>   |
|                                                                                |
|                                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

To select the rows:

1. Type the criteria you want to use to select the rows to change. Leave a null in any field for which you are not specifying selection criteria. Press the Clear function key to clear all the fields and set them to the null or column default indicator. Press the Show Field function key to see the data type for a column.

   If you want to select all the rows in the table, press Enter.

   If you want to select a specific set of rows to change, you can use the underscore (_) and the percent sign (%) as selection symbols to specify selection criteria for any column that contains character or graphic data.

   • Use an underscore to fill in for one character.
   • Use the percent sign to fill in for zero or more characters.
2. Press the Search function key.

To search on ROWID, you must specify a valid hexadecimal value for an existing ROWID. You cannot update a ROWID value in a table. ROWID values are managed dynamically by DB2.

The Table Editor Change panel displays with the first row you selected.