Export Utility ("To") panel

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. FM/Db2 writes the data to the output file as a comma-delimited (CSV) file. Db2® data exported in this way cannot be imported using Import (option 3.6). The data is intended for use by a spreadsheet application program.

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.