Previous Page | Next Page

Data Set Options for Relational Databases

BL_BADDATA_FILE= Data Set Option



Specifies where to put records that failed to process internally.
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_BADDATA_FILE=filename

Syntax Description

filename

specifies where to put records that failed to process internally.


Details

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

For bulk load, these are source records that failed internal processing before they were written to the database. For example, a record might contain only six fields, but eight fields were expected. Load records are in the same format as the source file.

For extraction, these are records that were retrieved from the database that could not be properly written into the target format. For example, a database value might be a string of ten characters, but a fixed-width format of only eight characters was specified for the target file.


See Also

BL_DISCARDS= Data Set Option

BULKEXTRACT= Data Set Option

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page