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.

Related tasks

• Where you can use templates
• Viewing and changing Db2 data

Related references

• TEDIT primary command
• Column Selection/Edit panel