Print Utility panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                        
 FM/Db2 (DFG2)                   Print Utility

 Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . . SYSIBM            +     Table space           (optional)
    Name  . . . . . . . SYSCOPY                                             +

    Row count . . . . . 20             Number of rows to print

 Db2 Template:
    Data set name . . .                                               
    Member  . . . . . .         

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

Location

The location of the Db2® object. Leave this field blank if the table or view that you want to work with is at your current location. This field is optional.

database

The name of the database to which you want to restrict your selection. This field is optional.

Owner

The authorization ID of the owner of the Db2® object. This field is optional.

Table space

The name of the table space to which you want to restrict your selection. This field is optional.

Name

The name of the Db2® object.

Row count

The number of rows of the Db2® object you want to print.

Valid values:

0

All rows printed

1–99999999

Number of rows printed

ALL

All rows printed. This is the default.

Data set name

The name of the template data set. 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 name or a member name pattern.

Processing Options

You can use these options to specify, amongst other things, the format in which you want the data printed, which template you want to use for the print process, and whether you want to edit the template before the print process.

Template usage

The Print Utility 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.

You can select the following options by entering a “∕” or an “A”:

Edit options

Use to display the FM/Db2 print utility options, prior to printing the data for the Db2® object. The default is not selected.

Edit template

Use to edit the template before printing the data. The default is not selected.

Create audit trail

Controls whether access to Db2® by FM/Db2 is written to the FM/Db2 audit log. This option only appears when SAF-rule controlled auditing is in effect.

FM/Db2 may write audit records to either SMF, or a data set.

When SAF rules are used to control FM/Db2 auditing, the decision to write audit records is based on the Db2® object name being processed, and the current userid (TSO logonid). Therefore auditing may be required when processing one Db2® object, but not another. In addition, it is possible that the auditing requirement cannot be changed for a particular Db2® object; this might be different for another Db2® object, and the requirement may be different for other TSO userids.

If you do not have the authority to change the audit setting when processing a particular Db2® object, FM/Db2 prompts you if you enter the wrong setting. If you do have the authority to set the audit setting for a particular Db2® object, FM/Db2 honors whatever value is specified in this field.