Import Options panel

Panel and field definitions

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

 Import dataset:
    Data format                         CSV Options
    1  1. FM/Db2 (SQLDA) format           Headings
       2. Db2 UNLOAD format               DBCS
       3. DSNTIAUL format                 Single quotes
       4. User defined                    Null indicator
       5. CSV                           , CSV delimiter

 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
5. CSV

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.

CSV Options

Headings

Select this option if the CSV data set to be imported includes headings.

DBCS

Select this option if the CSV data set to be imported includes double-byte data (DBCS) characters wrapped in shift-in (x'0E') and shift-out (x'0F') characters.

Single quotes

Select this option if the CSV data set to be imported has single quote encapsulation.

Null indicator

Use this field to specify the null indicator value that was used to represent a null value in the CSV input data set. A nullable column will be set to null when the corresponding CSV value has:

• A non-blank null indicator value.
• A null CSV value. For example, two successive delimiters ',,'.

CSV delimiter

Use this field to specify an alternate delimiter value to the comma "," character.

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.