Data editing capabilities

QMF for TSO and CICS® and QMF for Workstation both include a table editing interface that allows users to easily and intuitively update data in database tables.

In QMF for Workstation, you can select a table from your workspace, then insert or delete rows or update specific columns or entire rows.

The following figure shows the table editing interface in QMF for Workstation.
Figure 1. The table editing interface in QMF for Workstation
This figure shows the table editing interface in QMF for Workstation. The STAFF sample table is shown, with data in the following columns, labeled 1 through 7: ID, NAME, DEPT, JOB, YEARS, SALARY, and COMM. A pop-up menu is shown with the following choices: Copy, Delete Row, and Edit Row.
In QMF for TSO and CICS, you can use the Table Editor to edit individual rows or sets of rows that meet certain criteria. The Table Editor has three modes:
Allows you to search for the row or set of rows that you want to change
Allows you to insert rows into the table
Allows you to update or delete rows in the table

The following figure shows the ADD panel of the Table Editor, with a row being inserted into a table named SUPPLIERS, owned by user KRISTI.

Figure 2. ADD panel of the Table Editor in QMF for TSO and CICS
 ADD                  KRISTI.SUPPLIERS
                                                                   1 to 7 of 7
 ACCTNO. . . . . . . . (_15002__)
 COMPANY . . . . . . . (_S & J Supply Co.__________)
 STREET. . . . . . . . (_948 C Street_________)
 CITY. . . . . . . . . (_Boston_______________)
 STATE . . . . . . . . (_MA_)
 ZIP . . . . . . . . . (_02297__)
 NOTES . . . . . . . . (_-__________________________________________________>

Editing data is as easy as typing over the values on the Table Editor panel while you are in Change mode and pressing the Change key. In both Add and Change mode, you can choose to apply your edits immediately or batch multiple edits into a single transaction.

Default confirmation panels help to ensure security and integrity by prompting the user before making any updates final. You can set global variables that control the types of updates for which the confirmation panels are displayed. For extra security, you can also use column-level authorization to control exactly which columns of a table a user can view or change.