Online Documentation for SQL Manager for DB2

Specifying data source and destination


At this step you need to specify the data source and destination table for the import operation.

 

CLP Import - Specifying data source and destination

 

 

Name of the external file from which the data are to be imported | Destination for error, warning, and informational messages returned by the utility

Type in or use the ExplorerButton and the btnSaveAs buttons to specify the path to the file and the file name.

 

File type

Select the type of the data source file. Supported file types are:

Delimited ASCII (*.del)

Non-delimited ASCII (*.asc)

Worksheet formats (*.wsf)

Integration Exchange Format (*.ixf)

 

Selected action

Use the drop-down list to specify the action to be performed by the utility:

 

INSERT

Adds the imported data to the table without changing the existing table data.

 

INSERT_UPDATE

Adds rows of imported data to the target table, or updates existing rows (of the target table) with matching primary keys.

 

REPLACE

Deletes all existing data from the table by truncating the data object, and inserts the imported data. The table definition and the index definitions are not changed. This option can only be used if the table exists. If this option is used when moving data between hierarchies, only the data for an entire hierarchy, not individual sub-tables, can be replaced.

 

REPLACE_CREATE

If the table exists, deletes all existing data from the table by truncating the data object, and inserts the imported data without changing the table definition or the index definitions. If the table does not exist, creates the table and index definitions, as well as the row contents, in the code page of the database. See Imported table re-creation for a list of restrictions. This option can only be used with .ixf files. If this option is used when moving data between hierarchies, only the data for an entire hierarchy, not individual subtables, can be replaced.

 

CREATE

Creates the table definition and row contents in the code page of the database. If the data was exported from a DB2 table, sub-table, or hierarchy, indexes are created. If this option operates on a hierarchy, and data was exported from DB2, a type hierarchy will also be created. This option can only be used with IXF files.

 

 

Destination

This section allows you to define destination for importing data. Use the Schema and Table drop-down lists to specify the schema and table into which the data are to be imported.

 

 

Click the Next button to proceed to the Specifying common file modifiers step of the wizard.