BL_EXCEPTION= Table Option

Specifies the exception table into which rows in error are copied.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_EXCEPTION= exception-table-name

Arguments

exception-table-name

specifies the exception table into which rows in error are copied.

Details

Any row that is in violation of a unique index or a primary key index is copied. DATALINK exceptions are also captured in the exception table. If you specify an unqualified table name, the table is qualified with the CURRENT SCHEMA. Information that is written to the exception table is not written to the dump file. In a partitioned database environment, you must define an exception table for those partitions on which the loading table is defined. However, the dump file contains rows that cannot be loaded because they are not valid or contain syntax errors.
For more information about using this option, see the FOR EXCEPTION parameter in IBM DB2 Universal Database Data Movement Utilities Guide and Reference. For more information about the load exception table, see the load exception table topics in IBM DB2 Universal Database Data Movement Utilities Guide and Reference and IBM DB2 Universal Database SQL Reference, Volume 1.

See Also

Table Options: