Editing a template

FM/Db2 always uses a template to display Db2® data.

The discussion in this section provides examples based on editing a template while you are browsing the sample data shown in Sample data.

You can use either of the following methods to edit a template:

  • On an entry panel where you can use templates:
    1. Specify the template you want FM/Db2 to use (by selecting the appropriate Template usage option and, if required, specifying the name of the template).
    2. Select the Edit template field.
    3. Press Enter.

    FM/Db2 presents the template for editing, then runs the function after you have finished editing.

    If you edit a template in this way, you can change all parts of the template (including row selection criteria).

  • If you are using Browse (option B), View (option 1), or Edit (option 2) to browse, view, or edit data, you can use the TEDIT primary command.
    Note:
    1. You can only use the TEDIT primary command from within a File Manager/Db2 editor session (if you have the data displayed). You cannot use TEDIT from either the Db2® View or Db2® Edit function panels.
    2. If you use the TEDIT primary command, you cannot change the Order, A/D, or Row Selection Criteria input fields.

      The reason you cannot alter these parts of the template is that a File Manager/Db2 editor session is in progress and the session can contain uncommitted changes to data. Altering the preceding parts of the template might require data to be retrieved from Db2® using a new (and possibly different) SQL statement.

When you edit a template (using either of the preceding methods), FM/Db2 displays the Column Selection/Edit panel.

When you have finished editing the template using the Column Selection/Edit panel, you can:
  • Use the edited template on the fly without saving it by pressing the RunTemp function key (F6),
  • Optionally save the edited template before returning to the FM/Db2 function panel by pressing the Exit function key (F3), or
  • Return to the FM/Db2 function panel without saving the template by pressing the Cancel function key (F12).

Related tasks

Related references