Specifying details for the "From" table

Specify the name of the source (From) table on the Copy Utility From panel. If the table you specify does not exist, FM/Db2 issues an error message and stops the utility.

If you do not want to copy all of the rows in the From table, specify the number of rows you want to copy (1–99999999) in Copy Count.

If you are using a specific template for the From table (see options 1 and 4 in Template usage), specify the name of the template data set and, optionally, the member name, in the From Template entry fields.

The Processing Options specify which template you want to use for the From 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 From 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 From 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 From 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 template
Use to edit the template for the From table before proceeding to the Copy Utility To panel.
Copy “From” values to “To” panel
Use to copy the values (Db2® object Location, Owner, Name, and template Data set name, Member) entered on the From panel to the corresponding fields on the To panel.

To proceed, press Enter.

If you selected Edit template (either by using a “/”, or by having previously used the A selection character for this option), the Column Selection/Edit panel is displayed. Otherwise, the Copy Utility To panel is displayed.

Related tasks

Related references