Previous Page | Next Page

Data Set Options for Relational Databases

BL_EXCEPTION= Data Set Option



Specifies the exception table into which rows in error are copied.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under UNIX and PC Hosts, Greenplum

Syntax
Syntax Description
Details
See Also

Syntax

BL_EXCEPTION=exception table-name

Syntax Description

exception table-name

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


Details

To specify this option, you must first set BULKLOAD=YES.

DB2 under UNIX and PC Hosts: 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.

Greenplum: Formatting errors are logged when running in single-row, error-isolation mode. You can then examine this error table to determine whether any error rows were not loaded. The specified error table is used if it already exists. If it does not, it is generated automatically.


See Also

For more information about using this option with DB2 under UNIX and PC Hosts, see the FOR EXCEPTION parameter in the 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 the IBM DB2 Universal Database Data Movement Utilities Guide and Reference and the IBM DB2 Universal Database SQL Reference, Volume 1.

BULKLOAD= Data Set Option

Capturing Bulk-Load Statistics into Macro Variables

Previous Page | Next Page | Top of Page