72 BL_LOG= LIBNAME Option Chapter 9
YES
specifies that Microsoft SQL Server preserves NULL values inserted by the OLE DB
interface.
NO
specifies that Microsoft SQL Server replaces NULL values that are inserted by the
OLE DB interface with a default value (as specified in the DEFAULT constraint).
Details
This option only affects values in Microsoft SQL Server columns that accept NULL
and have a DEFAULT constraint.
See Also
To apply this option to an individual data set, see the data set option
“BL_KEEPNULLS= Data Set Option” on page 156.
BL_LOG= LIBNAME Option
Specifies the name of the error file to which all errors are written when BULKLOAD=YES
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, Microsoft SQL Server
Default value: none
Syntax
BL_LOG=filename
Details
This option is only valid for connections to Microsoft SQL Server. If BL_LOG= is not
specified, errors are not recorded during bulk loading.
See Also
To apply this option to an individual data set, see the data set option “BL_LOG=
Data Set Option” on page 158.
BL_OPTIONS= LIBNAME Option
Passes options to the DBMS bulk load facility, affecting how it loads and processes data
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, OLE DB
