Online Documentation for SQL Manager for DB2

Setting IMPORT/LOAD options


Use this step of the wizard to define options for the IMPORT/LOAD operation.

 

Note: The step is available only if the IMPORT or LOAD action was specified at the Specifying DB name and connection parameters step.

 

CLP Move - Setting IMPORT_LOAD options

 

 

Action mode

Use the drop-down list to select one of available import/load modes which determine the method in which the data is imported/loaded:

INSERT (for IMPORT and LOAD)

INSERT_UPDATE (for IMPORT only)

REPLACE (for IMPORT and LOAD)

CREATE (for IMPORT only)

REPLACE_CREATE (for IMPORT only)

The first three, INSERT, INSERT_UPDATE, and REPLACE are used when the target tables already exist. All three support IXF, WSF, ASC, and DEL data formats. However, only INSERT and INSERT_UPDATE can be used with nicknames. The other two modes, REPLACE_CREATE and CREATE, are used when the target tables do not exist. Load has only two modes: REPLACE and INSERT.

 

Working directory

Type in or use the ExplorerButton button to specify the path to the working directory for importing/loading data.

 

Path to LOB files

Type in or use the ExplorerButton button to specify the path to the directory for LOB files.

 

 

Click Next to proceed to the Moving data step of the wizard.