Specifying the Db2® object you want to view

This section describes how you specify the Db2® object you want to view when you use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/Db2 Browse Utility (option B) to view Db2® data or, in the case of edit, to optionally change Db2® data. The descriptions apply to the Db2® View panel, Db2® Edit panel, and Db2® Browse panel respectively.

To specify the table you want to view, use the Name entry field and, optionally, the Location, Owner, Database, and Table space entry fields.

To specify the template that you want FM/Db2 to use when viewing the data, use a combination of the Template and Template usage entry fields. You can:

  • Specify a template that describes the format of the Db2® object:
    • Use Data set name, and optionally Member, to specify the template.
    • Select 1 (Above).
  • Use the last (previously used) template:
    • Select 2 (Previous).

    Any values in the Data set name and Member fields are ignored.

  • Use FM/Db2 to generate a template using the information in the Db2® catalog:
    • Select 3 (Generate from table). This is the default setting.

    Any values in the Data set name and Member fields are ignored.

  • Use FM/Db2 to generate a template using the information in the Db2® catalog and store the generated template using the name you specify (if the data set already exists, FM/Db2 replaces it):
    • Use Data set name, and optionally Member, to specify the name that you want FM/Db2 to use if storing the generated template.
    • Select 4 (Generate/Replace).
You can select this option to change the options for the current editor session:
Edit options
Enter one of these:
A “∕” or an “A”
Displays the first FM/Db2 editor options panel, prior to displaying the data for the Db2® object being processed.
A number in the range 1–8
Displays the nth FM/Db2 editor options panel directly where n is the value entered.

Any options that you set last only for the duration of the current Edit session, and override any conflicting global options. To permanently change the Edit options, select option 0.2.

You can select the following options by entering a “∕” or an “A”:
Edit template
Select this option to edit the template before editing the data.
Re-edit template
Select this option to control the navigation between panels within the Edit dialog. This option controls the behavior of the F3 and F12 keys when pressed from within an Edit session.
Create audit trail
Select this option to generate an audit trail report of all successful modifications to Db2® data made during the current Edit session.
Note: This option is not displayed if SAF-rule controlled auditing is not in effect. See SAF-rule controlled auditing.
Note: Entering an “A” in an option field changes the behavior of the dialog so that the appropriate options panel is always displayed. If you only need to refer to an options panel on one occasion, use the “∕” character. The “∕” is cleared after the option is processed, thereby returning the dialog to the default behavior, which is to not show the various option panels.

Related tasks

Related references