Export Utility ("To") panel

You use the Export “To” panel to specify the name of the data set that contains the data to be exported, the (optional) name of a template data set, and processing options.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
             From DSN81010.EMP
 Command ===>  

 To Partitioned, Sequential or VSAM Data Set:
    Data set name . . .                                              
    Member  . . . . . .         
    Volume  . . . . . .       

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

 Processing Options:
    Template/Copybook usage     Disposition           Enter "/", "A"lways
    3   1. Above                2  1. Old or Reuse    _  View options
        2. Previous                2. Mod             A  Edit template mapping
        3. Generate from table
        4. Generate/Replace                           Generated copybook
        5. None. (CSV output)                         1  1. No display
       6x. Gen/Rep copybook (x=AOP)                      2. View
                                                         3. Edit
 Command ===>                                                                 
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel
Data set name (To Partitioned, Sequential or VSAM Data Set)
The name of the output data set.
Member (To Partitioned, Sequential or VSAM Data Set)
The output member name (if applicable).
Volume
The volume serial number if the data set is not catalogued.
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 may include a member name or name pattern in parenthesis. If the member is specified here, 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 parenthesis in the Data set name field, then you can use this field to specify the member name or a member name pattern.
Template usage
The Export Utility To panel provides five options for template processing:
1. Above
Requires that you 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 have specified the member containing a copybook or template, processing continues using this template in place of the automatically-generated template for the table (see Template usage option 3).
2. Previous
Uses the last (previously used) template for this table.
3. Generate from input
Generates a template based on the input template, but which includes only those columns selected in the input template. If you have specified a data set name in the To Copybook or Template section of the panel, it is ignored. The generated template is not saved.
4. Generate and save
Generates a template based on the input template, but which includes only those columns selected in the input template. This option requires you to 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. (CSV output)
FM/Db2 does not use an output template. This option is only valid when the export data format is set to CSV.
Gen/Rep copybook (x=AOP)
Generates and saves a copybook that describes the exported data. This option requires you to enter the name of a copybook 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 copybook is saved, replacing any member with the same name.
  • Specify 6A to generate and save a High Level Assembler copybook.
  • Specify 6O to generate and save a COBOL copybook.
  • Specify 6P to generate and save a PL/I copybook.
Disposition
The disposition for the data set that contains the exported data.
1. Old or Reuse
Specify '1' when the export data set exists, and the exported data is to replace any existing data.
2. Mod
Specify '2' in one of the following conditions:
  • The export data does not exist, and needs to be created.
  • The export data set exists, and the exported data is to be added to any existing data.
You can select the following options by entering a ⁄ or an “A”:
Edit options
Select this option to display the second of the Export Options panels. 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 exporting the data, before exporting the data. The default is not selected.
Note: Template mapping does not apply for CSV output. See the template usage option 5. None. (CSV output).

Parent panels

Child panels

To display this panel… Use/do this
Template Mapping panel Select Edit template mapping

Related tasks