Online Documentation for SQL Manager for DB2

Specifying action


Use this step of the wizard to specify the CLP load action.

 

CLP Load - Specifying action

 

 

Selected action

 

INSERT

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

 

REPLACE

Deletes all existing data from the table, and inserts the loaded data. The table definition and the index definitions are not changed.

 

RESTART

Restarts a previously interrupted load operation. The load operation will automatically continue from the last consistency point in the load, build, or delete phase.

 

TERMINATE

Terminates a previously interrupted load operation, and rolls back the operation to the point in time at which it started, even if consistency points were passed.

 

Dictionary

 

RadioButton Keep dictionary

All processed rows are subject to compression using the existing dictionary

RadioButton Reset dictionary

A new row compression dictionary is built, and all processed rows are subject to compression using this new dictionary.

 

Exception table

 

CheckBox Use exception table

Specifies that an exception table will be used for the load operation. Any row that is in violation of a referential or check constraint will be deleted from your table and copied to the exception table.

 

Use the Schema and Table drop-down lists to specify the schema and table to be used as the exception table.

 

You can also choose whether to CheckBox insert rows with a range violation and CheckBox insert rows with a unique constraint violation into the exception table or not.

 

 

Click the Next button to proceed to the Specifying LOB source step of the wizard.