Data Set Options for Relational Databases |
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 |
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 |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.