Specifying details for the "To" table
Specify the name of the table to which the input data is to be
imported on the Import Utility To
panel. If the table you specify
does not exist, FM/Db2 issues an error message.
If you are using a specific template for the To
table (see
options 1 and 4 in Template usage), specify the name of the
template in the To Template entry fields.
To delete all the rows in the target table before importing the data from the QSAM or VSAM data set, select the Delete existing rows option.
duplicateof an existing row. That is, where the only changes to the data are in columns that are not part of any unique index key:
- To ignore duplicate rows, select 1. Ignore.
Any duplicates that FM/Db2 detects are not updated and FM/Db2 ignores the value (if any) in the For … duplicates field.
- To update duplicate rows, select 2. Update.
FM/Db2 updates any duplicate rows. If the number of duplicates exceeds the value specified in the For … duplicates field, FM/Db2 terminates the import operation and all changes are rolled back.
To proceed, press Enter.
If you selected Edit template mapping (either by using a “/”,
or by having previously used the A
selection character for
this option), then, before FM/Db2 imports the data, 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, FM/Db2 imports the data from the From
data set
to the To
Db2® table.
Related tasks
- Specifying a Db2 object name
- Specifying a data set and a member name
- Mapping data
- Running Import in batch
Related references