Db2® Edit panel

You use the Db2® Edit panel to enter the name of an object to be edited. You also use this panel to specify the name of a template that describes a logical view of the object.

Panel and field definitions

  Process   Options   Help
────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                      Db2 Edit

 Specify the Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . . FMNUSER           +     Table space           (optional)
    Name  . . . . . . . EMP                                                 +
    Start position  . . 1         
    Row count . . . . . 100            Number of rows to edit

 Template:
    Data set name . . . 'FMNUSER.TEMPLATE'                            
    Member  . . . . . . SALARY  

 Processing Options:
    Template usage                     Enter "/", "A"lways to select option
    3  1. Above                           Edit options
       2. Previous                        Edit template
       3. Generate from table             Re-edit template
       4. Generate/Replace                Create audit trail
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Location

The location name for the Db2® object. You can specify a generic name to select from a list. If you enter a value in this field, synonym object names are not recognized or included in the selection list.

Database

The database name for the Db2® object. You can use this field to optionally specify a database to further define the object to be processed. If you enter a value in this field:

The values displayed in the Owner and Name selection lists are limited to those values defined within the specified database.
Synonym names are not recognized or included in the selection list.

Owner

The name of the owner of the object. You can specify a generic name to select from a list. To specify a synonym in the object Name field, either leave this field blank, or specify a generic name that includes the current SQLID or specify the current SQLID. Synonyms are not recognized or included on the table selection list if any of the Table space, Database, or Location fields are non-blank.

If the Translate Db2® object names option is selected, lowercase characters are converted to uppercase. If this option is not selected, lowercase characters are not converted to uppercase; in this situation, a lowercase owner name such as sysibm does not match SYSIBM in the Db2® catalog.

Table space

The table space name for the Db2® object. To further define the object to be processed, you can use this field to optionally specify a table space. If you enter a value in this field:

The values displayed in the Owner and Name selection lists are limited to those values defined within the specified table space.
Synonym names are not recognized, nor included in the selection list.

Name

The name of the object name to be processed. You can specify a generic name to select from a list. To specify a synonym in this field, type the name of the synonym and ensure that the Owner field is blank, contains a generic name that includes the current SQLID, or contains the current SQLID. Synonyms are not recognized or included in the table selection list if any of the Table space, Database, or Location fields are non-blank.

Start position

Indicates where FM/Db2 is to begin loading rows from the result table into the FM/Db2 editor.

If you specify a value greater than 1 (the default), FM/Db2 skips n-1 rows of the result table before loading rows into the FM/Db2 editor. If the Row count value is ALL (or 0 or *), when the data is displayed you can scroll up to see the rows that were skipped. For a fixed Row count value, you cannot scroll backwards to see any skipped rows.

Row count

Use this option to specify the maximum number of rows to be retrieved from Db2® and loaded into memory for the editor session. You can specify a value in the range 1–999999999 or, to indicate that all rows are to be retrieved, specify ALL, 0, or *. The default value is 100.

A File Manager/Db2 editor session only applies to those rows fetched from Db2® and loaded into the editor. It does not apply to any unfetched rows. This means that the FIND and CHANGE primary commands only apply to those rows fetched from Db2®.

Note: When you are editing large tables, use the value of 0 with caution as it is possible to encounter storage problems. The amount of storage required by the editor depends on both the number of rows retrieved, and the row length. Use the row selection criteria section of the template to limit the number of rows retrieved.

Data set name

The name of a data set that contains, or will contain, the template. It can be a fully-qualified data set name or a pattern. The name may include a member name or name pattern in parenthesis. If the member is specified here, the associated Member field must be empty.

Member

If you specified the name of a partitioned data set (PDS) without including a member name or name pattern in parenthesis in the Data set name field, then you can use this field to specify the member vname or a member name pattern.

Template usage

The Db2® Edit panel provides four options for template processing:

1. Above: Requires that you enter the name of a template data set (and optionally a member name) in the Template section of the panel. If you do not specify a member name, or if you specify a pattern, FM/Db2 displays a member selection list. After you have specified the member containing a template, processing continues using this template in place of the automatically-generated template for the table (for a detailed explanation, see Template Usage option 3).
2. Previous: Uses the last (previously used) template for this table.
3. Generate from table: Generates a template based on the information in the Db2® catalog for the specified table. This is the default setting. If you have specified a member name in the Template section of the panel, it is ignored. FM/Db2 generates the required template in memory.
4. Generate/Replace: Generates a template based on the information in the Db2® catalog for the specified table, and saves this information in the member specified in the Template section of the panel. If the member already exists, it is replaced. Any prior customization is lost.

Edit options

The default is not selected. Select this option to change the options for the current editor session by entering one of the following values:

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. The default is not selected.

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. The default is not selected.

Create audit trail

Note: "(*)" is appended to the option name for SAF-controlled auditing when required by SAF rules.

Determines if FM/Db2 generates an audit trail report of all successful modifications to Db2® data made during an Edit session:

⁄: Audit trail report generated.
(blank): Audit trail report not generated.

Note: The ability to change this option depends on installation options within the Db2® subsystem to which FM/Db2 is connected. The Create an audit trail option can be:

Permanently selected (/ shown in the option). Audit trail reporting occurs for Edit processing. You cannot change the setting of the option.
Permanently deselected (blank shown in the option). Audit trail reporting does not occur for Edit processing. You cannot change the setting of the option.
Optional. Type a / in the option to generate audit reporting for all Edit processing; otherwise, type a space in the option to suppress audit trail reporting of any Edit processing.

At the end of your FM/Db2 session, the Create an audit trail option that you specify can be saved to your ISPF profile, or it can be set to blank (audit trail report not selected), depending on the installation options within the Db2® subsystem to which FM/Db2 is connected. The audit installation options for the currently connected Db2® system can be determined by selecting option 7 from the HELP pull down menu. When the auditing option is OPTIONAL,OFF, the Create an audit trail option is always reset to blank (not selected) at the start of a File Manager/Db2 session. This means that, for an audit log to be written, auditing must be explicitly selected each time a new FM/Db2 session is started. Further, when this option is selected, there is no distinction between the global setting for the audit option, and any value entered using 'edit options' on the Db2® edit panel. For more information, see the File Manager Customization Guide or see your systems administrator.

Parent panels

Child panels


To display this panel…	Use/do this
Table Edit panel	No options selected and press Enter
Editor Options (1 of 8) panel	Select Edit options by typing a ⁄, an “A”, or “1”
Editor Options (2 of 8) panel	Select Edit options by typing a “2”
Editor Options (3 of 8) panel	Select Edit options by typing a “3”
Editor Options (4 of 8) panel	Select Edit options by typing a “4”
Editor Options (5 of 8) panel	Select Edit options by typing a “5”
Editor Options (6 of 8) panel	Select Edit options by typing a “6”
Editor Options (7 of 8) panel	Select Edit options by typing a “7”
Column Selection/Edit panel	Select Edit template or Re-edit template

Db2® Edit panel

Panel and field definitions

Parent panels

Child panels

Related tasks