Online Documentation for SQL Manager for DB2

Specifying common file modifiers


Specify common file modifiers at this step of the wizard.

 

CLP Import - Specifying common file modifiers

 

 

General options

 

CheckBox Do not import default values for columns that are not nullable

Enable the option if you do not want to import default values into not nullable columns that are not explicitly specified in the source column. With this option disabled, default values will be imported if they can be specified.

 

CheckBox Suppress all warnings about rejected rows

Enable the option to let DB2 ignore such warnings during the import process.

 

 

Field defaults

 

Identity column behavior

 

IDENTITY MISSING modifier makes importing a table with an identity column more convenient if the input data file does not contain any values (not even NULLS) for the identity column.

 

IDENTITY IGNORE modifier indicates to the import utility that even though the input data file contains data for the identity column, the data should be ignored, and an identity value should be generated for each row.

 

Generated column behavior

 

GENERATED MISSING modifier makes importing a table with generated columns more convenient if the input data file does not contain any values (not even NULLS) for all generated columns present in the table.

 

GENERATED IGNORE modifier indicates to the import utility that even though the input data file contains data for all generated columns present in the target table, the data should be ignored, and the computed values should be loaded into each generated column.

 

CheckBox Use defaults for blank

Enable this option to substitute blank values with default values.

 

 

If the Integration Exchange (IXF) format was specified at the Specifying data source and destination step, additional options are available:

 

CLP Import - Specifying common file modifiers - IXF

 

 

CheckBox Suppress translation between code pages

Enable this option to direct the utility to accept data despite code page mismatches, and to suppress translation between code pages.

 

CheckBox Import row, even if the source data size exceeds the size of the target column

If the option is enabled, no checking target length is performed. An attempt is made to import each row, even if the source data has a column definition that exceeds the size of the target table column.

 

CheckBox Drop existing indexes and create new ones

This option directs the utility to drop all indexes currently defined on the existing table, and to create new ones from the index definitions in the IXF file. This option can only be used when the contents of a table are being replaced.

 

 

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