Data Set Options for Relational Databases

BL_FAILEDDATA= Data Set Option

Specifies where to put records that could not be written to the database.

Default value:	creates a data file in the current directory or with the default file specifications
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS Support:	HP Neoview

Syntax

BL_FAILEDDATA=filename

filename: specifies where to put source records that have a valid format but could not be written to the database. For example, a record might fail a data conversion step or violate a uniqueness constraint. These records are in the same format as the source file.

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