LOAD Utility panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DB26)                    LOAD Utility

 Input Data:
    Data set name . .                                               
    Member  . . . . .           
    Volume  . . . . .       

 Utility Control Statements:
    Data set name . .                                                          
    Member  . . . . .         

 Target Db2 Table:
    Table owner .                            Database . .          (optional)
    Table name  .                            Table space           (optional)

    Select Option:
    1  1. The data is described by utility control statements
       2. The data is described by a template or copybook

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

Data set name (Input Data)

A sequential or partitioned data set that contains the data to be loaded into the Db2® table. Specify a generic data set name to select from a list. 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 (Input Data)

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.

Volume

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

Data set name (Utility Control Statements)

A sequential or partitioned data set that contains the Db2® load utility control statements. Specify a generic data set name to select from a list. 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 (Utility Control Statements)

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.

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.

Database

A fully or partially-qualified database name to limit the list of object names to the specified databases.

Table name

The name of the target table. You can specify at generic object name to select from a list. This field is mandatory.

Table space

A fully or partially-qualified table space name to limit the list of object names to the specified table spaces.

1. The data is described by utility control statements

Use the supplied Db2® load utility control statements when generating a Db2® load utility batch job.

2. The data is described by a template or copybook

Use a template or copybook when generating a Db2® load utility batch job.