Specifying details for the "To" table

Specify the name of the target (To) table on the Copy Utility To panel.

If you are using a specific template for the To table, specify the name of the template data set and, optionally, the member name, in the To Template entry fields.

The Processing Options specify which template you want to use for the To table, and whether you want to edit the template before the copy process.

Template usage

The Copy Utility panel provides four options for template usage:

1. Above: Requires that you enter the name of a template data set (and optionally a member name) in the To 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 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 member specified in the To Template section of the panel. If the member already exists, it is replaced. Any prior customization is lost.

You can select the following options by entering a “∕” or an “A”:

Edit copy options: Use to edit the Copy options before copying the data.
Edit template mapping: Use to edit the template mapping for the To table before copying the data.
Batch execution: Builds the necessary JCL to perform the Copy utility in a batch job.

To proceed, press Enter.

If you selected Edit Copy options (either by using a “/”, or by having previously used the A selection character for this option), the Copy Options panel is displayed for editing.

If you selected Edit template mapping (either by using a “/”, or by having previously used the A selection character for this option), the Template Mapping panel is displayed for editing.

If you selected Batch execution (either by using a “/”, or by having previously used the A selection character for this option), the generated JCL is displayed using the ISPF editor, where you can review the JCL and submit the job for batch processing.

Otherwise (if you selected none of the preceding options), FM/Db2 copies the data from the From table to the To table.