Copy Utility ("To") panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Copy from DSN8810.EMP

 To Db2 Object:
    Location  . . . . .                         Database . .          (optional)
    Owner . . . . . . . FMNUSER           +     Table space           (optional)
    Name  . . . . . . . EEMP                                                +



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

 Processing Options:
    Template usage                     Enter "/", "A"lways to select option
    3  1. Above                           Edit copy options
       2. Previous                        Edit template mapping
       3. Generate from table             Batch execution
       4. Generate/Replace
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Location

The location name for the Db2® object. You can specify a generic name to select from a list. If you enter a value in this field, synonym object names are not recognized or included in the selection list.

Database

The database name for the Db2® object. You can use this field to optionally specify a database to further define the object to be processed. If you enter a value in this field:

• The values displayed in the Owner and Name selection lists are limited to those values defined within the specified database.
• Synonym names are not recognized or included in the selection list.

Owner

The name of the owner of the object. You can specify a generic name to select from a list. To specify a synonym in the object Name field, either leave this field blank, or specify a generic name that includes the current SQLID or specify the current SQLID. Synonyms are not recognized or included on the table selection list if any of the Table space, Database, or Location fields are non-blank.

If the Translate Db2® object names option is selected, lowercase characters are converted to uppercase. If this option is not selected, lowercase characters are not converted to uppercase; in this situation, a lowercase owner name such as sysibm does not match SYSIBM in the Db2® catalog.

Table space

The table space name for the Db2® object. To further define the object to be processed, you can use this field to optionally specify a table space. If you enter a value in this field:

• The values displayed in the Owner and Name selection lists are limited to those values defined within the specified table space.
• Synonym names are not recognized, nor included in the selection list.

Name

The name of the object name to be processed. You can specify a generic name to select from a list. To specify a synonym in this field, type the name of the synonym and ensure that the Owner field is blank, contains a generic name that includes the current SQLID, or contains the current SQLID. Synonyms are not recognized or included in the table selection list if any of the Table space, Database, or Location fields are non-blank.

If the Translate Db2® object names option is selected, lowercase characters are converted to uppercase. If this option is not selected, lowercase characters are not converted to uppercase; in this situation, a lowercase owner name such as sysibm does not match SYSIBM in the Db2® catalog.

Data set name

The name of a data set that contains, or will contain, the template. 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 Copy Utility panel provides four options for template processing:

1. Above

Requires that you enter the name of a template data set (and optionally a member name) in the 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 template, processing continues using this template in place of the automatically-generated template for the table (for a detailed explanation, see Template Usage option 3).

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 member name in the 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 member specified in the To Template section of the panel. If the member already exists, it is replaced. Any prior customization is lost.