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.
- SEARCH
- Allows you to search for the row or set of rows that you want to change
- ADD
- Allows you to insert rows into the table
- CHANGE
- 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.
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.