UNLOAD Utility (Tables) "To" panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FMN2PEYO om DSN81010.EMP                                       NOPAD specified
 Command ===>

 Output Sequential Data Set: 
    Data set name . . .                                               
    Volume  . . . . . .       

 To Copybook or Template:
    Data set name . . .                                              
    Member  . . . . . .         

 Processing Options:
    Template usage             Disposition           Enter "/", "A"lways
    4  1. Above                2  1. Old or Reuse       View UNLOAD options
       2. Previous                2. Mod                Edit template mapping
       3. Generate from input
       4. Generate and save
       5. None


 Command ===>                                                                 
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Data set name

The name of the data set or PDS member that contains the unloaded data. The name can be a fully qualified data set name or a pattern. The name cannot include a member name, which is a restriction that is imposed by the Db2® UNLOAD utility.

Volume

The volume serial number if the data set is not cataloged.

Data set name (To Copybook or Template)

The name of the sequential or partitioned data set that contains the copybook or template that describes the data set. It can be a fully qualified data set name or a pattern. The name might include a member name or name pattern in parentheses. If the member is specified, the associated Member field must be empty.

Member (To Copybook or Template)

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

Template usage

The Unload Utility “To” panel provides five options for template processing:

1. Above

You must enter the name of a copybook or template in the To Copybook or 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 specified the member that contains a copybook or template, processing continues by using this template instead of the template that is automatically generated for the table (see Template usage option 3).

2. Previous

Uses the last template or the template that was previously used for this table.

3. Generate from input

Generates a template based on the input template. However, the template includes the columns that are selected in the input template only. If you specified a data set name in the To Copybook or Template section of the panel, this option is ignored. The template that is generated is not saved.

4. Generate and save

Generates a template based on the input template. However, the template includes the columns that are selected in the input template only. To enable this option, you must enter the name of a template data set and optionally a member name in the To Copybook or 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. The generated template is saved.

5. None.

FM/Db2 does not use an output template.

Disposition

The disposition for the data set that contains the unloaded data.

1. Old or Reuse

Specify '1' when the unload data set exists, and the unloaded data is to replace any existing data.

2. Mod

Specify '2' in one of the following conditions. This is the default.

• The unload data does not exist, and it is to be created.
• The unload data set exists, and the unloaded data is to be added to any existing data.

View UNLOAD options

Select this option to show the view of the current UNLOAD options. The default is not selected.

Edit template mapping

Use to edit the template for the partitioned, sequential, or VSAM data set to which you are unloading the data, before you unload the data. The default is not selected.