LOAD from panel

You use the LOAD Utility: “To” template panel to specify the template for the target Db2® table when you use the LOAD utility.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Load from template LODINDDN

 Target Db2 Table:
    Owner . . . . . . . FMNUSER           +
    Name  . . . . . . . EMP                                                 +

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

 Processing Options:
    Template usage                     Enter "/", "A"lways to select option
    3  1. Above                           Edit LOAD utility options
       2. Previous                        Edit template mapping
       3. Generate from table
       4. Generate/Replace



   Command ===>                                                                
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Table owner
The name of the owner for the target table. You can specify a generic object name to select from a list. This field is mandatory.
Table name
The name of the target table. You can specify at generic object name to select from a list. This field is mandatory.
Data set name
The name of the data set or PDS member containing the template for the To object. 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.
Template usage
The LOAD Utility: “To” template panel provides four options for template processing:
1. Above
Requires that you enter the name of a template in the To Template section of the panel.
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 data set name in the To 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 data set specified in the To Template section of the panel. If the template already exists, it is replaced and any prior customization is lost.
You can select the following options by entering a ⁄ or an “A”:
Edit load utility options
Displays the Load Utility Options panel
Edit template mapping
Use to edit the template for the table to which you are importing the data, before importing the data.

Parent panels

Child panels

To display this panel… Use/do this
LOAD Utility Options panel Select Edit LOAD utility options
Template Mapping panel Select Edit template mapping

Related tasks