BL_FAILEDDATA= Data Set Option

Specifies where to put records that could not be written to the database.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: creates a data file in the current directory or with the default file specifications
Requirement: To specify this option, you must first set BULKEXTRACT= YES or BULKLOAD=YES.
Data source: HP Neoview
See: BL_ERRORS= data set option, BULKEXTRACT= data set option, BULKLOAD= data set option

Syntax

BL_FAILEDDATA=filename

Syntax Description

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.