Data Set Options for Relational Databases |
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
|
- filename
-
specifies where to put records that failed to process internally.
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.
BL_DISCARDS= Data Set Option
BULKEXTRACT= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.