Specifying details for the "From" table

Specify the name of the source (From) table on the Export Utility 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 export all of the rows in the From table, specify the number of rows you want to export (1–99999999) in Export Count.

If you are using a specific template for the From table (see option 1 in Template usage), specify the name of the template in the From Template entry fields.

The Processing Options on the Export Utility panel specify which template you want to use for the From table, and whether you want to edit the template before the export process.
Template usage
The Export 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 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 (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 From 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 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 options
Use to display the first of the Export Options panels.
Edit template
Use to edit the template for the From table before proceeding to the Export Utility To panel.

To proceed, press Enter.

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

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 Export Utility To panel is displayed.

Related tasks

Related references