Import Options panel

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DG03)                   Import Options                 Global Settings

 Import dataset:
    Data format
    1  1. FM/Db2 (SQLDA) format
       2. Db2 UNLOAD format
       3. DSNTIAUL format
       4. User defined

 Import Options:
    Duplicate key processing              Enter "/" to select option
    1  1. Ignore                             Delete existing rows
       2. Update
       Max duplicates   ALL       

 Auto Commit (Changes):
    Auto-commit count . 0         


 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel

Data format

Allows you to specify the data format that corresponds to the template or copybook used:

• 1. FM/Db2 (SQLDA) format
• 2. Db2® UNLOAD format
• 3. DSNTIAUL format
• 4. User defined

The default is 1. (FM/Db2 (SQLDA) format).

Duplicate key processing

1. Ignore

Ignores duplicate rows. This is the default.

2. Update

Updates duplicate rows when Db2® returns a duplicate row error (SQLCODE -803) in response to an INSERT SQL statement. When you select this option, FM/Db2 attempts to update the existing row. All columns of the table that are part of at least one unique index are used to identify the row. No comparison is made between the imported row and the existing row prior to the update operation (that is, the update is done regardless of whether the imported row and existing row are the same). When you use this option it is recommended that you specify a Db2® table name, rather than a view name. FM/Db2 does not attempt to update existing rows in a view defined on a view.

Max duplicates

The maximum number of duplicates permitted.

Valid values: A number in the range 0–9999999999, or ALL. The default is ALL.

Auto-commit count

Use this option to take progressive Db2® commit points as records are imported. Any positive value entered will cause FM/Db2 to issue a Db2® commit automatically after the specified number of successful Db2® changes. A successful Db2® change is either the successful insert of a record; or the successful update of a row when a duplicate key error is encountered on the insert. The change counter is reset after each Db2® commit is issued, so multiple Db2® commit points may be issued. Specify a zero value if no progressive Db2® commit points are required; in this case the Db2® commit is deferred until the end of the import utility and any error encountered during the import will cause all changes to be backed out. The default for this option is 0.

Delete existing rows

Deletes all the rows in the target table before importing. The default is not selected; that is, no rows are deleted from the target table.