Previous Page | Next Page

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
Syntax Description
Details
See Also

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.


Details

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


See Also

BL_ERRORS= Data Set Option

BULKEXTRACT= Data Set Option

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page