Import Utility ("To") panel

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
             From SHRIKE2.EXPORT.EMP
 Command ===> 

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

 To Template:                      From  SHRIKE2.FM.TEMPLATE(EMP)
    Data set name . . .
    Member  . . . . . .           

 Processing Options:
    Template usage                     Enter "/", "A"lways to select option
    3  1. Above                           Edit options
       2. Previous                        Edit template mapping
       3. Generate from table             Batch execution
       4. Generate/Replace                Create audit trail (*)
                                          Use REXX proc
                                          REXX proc name  . .         

 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 the data set or PDS member containing the template for the To table. 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.
The Import Utility To 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 options
Select this option to display the Import Options panel. The default is not selected.
Edit template mapping
Use to edit the template for the table to which you are importing the data, before importing the data. The default is not selected.
Batch execution
Builds the necessary JCL to perform the Import utility in a batch job. The default is not selected.
Create audit trail
Note: "(*)" is appended to the option name for SAF-controlled auditing when required by SAF rules.
Controls whether access to Db2® by FM/Db2 is written to the FM/Db2 audit log. This option only appears when SAF-rule controlled auditing is in effect.

FM/Db2 may write audit records to either SMF, or a data set.

When SAF rules are used to control FM/Db2 auditing, the decision to write audit records is based on the Db2® object name being processed, and the current userid (TSO logonid). Therefore auditing may be required when processing one Db2® object, but not another. In addition, it is possible that the auditing requirement cannot be changed for a particular Db2® object; this might be different for another Db2® object, and the requirement may be different for other TSO userids.

If you do not have the authority to change the audit setting when processing a particular Db2® object, FM/Db2 prompts you if you enter the wrong setting. If you do have the authority to set the audit setting for a particular Db2® object, FM/Db2 honors whatever value is specified in this field.

Use REXX proc
Use this option to perform either of these actions:
  • Enter a temporary REXX procedure for one-time use by entering an asterisk (*). FM/Db2 displays a REXX edit panel that you can use to create a new REXX procedure. The default is not selected.
  • Specify the name of the member containing the REXX procedure you want to use. The member must belong to the PDS allocated to ddname FMNEXEC. You can enter any of the following:
    • The name of the member.
    • A member name pattern (other than *) to list all matching members. You can then select the required member by entering an S in the Sel field. A member name pattern can consist of any characters that are valid in a member name and the following two special pattern characters:
      asterisk (*)
      Represents any number of characters. As many asterisks as required can appear anywhere in a member name. For example, if you enter *d*, a list of all members in the data set whose name contains “d” is displayed.
      percent sign (%)
      A place-holding character representing a single character. As many percent symbols as necessary can appear anywhere in a member name. For example, if you enter %%%%, a list of all members in the data set whose name is four characters in length is displayed.
Note: The default for the member name is blank. If you select this option but leave the Use REXX proc field blank, FM/Db2 displays a member name list. You can then select the required member by entering S in the Sel field.

Parent panels

Child panels

To display this panel… Use/do this
Import Options panel Select Edit options

Related tasks