BL_KEEPNULLS= Data Set Option
Indicates how NULL values in Microsoft SQL Server
columns that accept NULL are handled during bulk load.
| Valid in: |
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
|
| Default: |
LIBNAME setting |
| Restriction: |
This option affects values in only Microsoft SQL Server
columns that accept NULL and that have a DEFAULT constraint.
|
| Requirement: |
To specify this option, you must first set BULKLOAD=YES. |
| Data source: |
OLE DB |
| See: |
BL_KEEPNULLS= LIBNAME option, BULKLOAD= data set option |
Syntax
Syntax Description
- YES
-
preserves null values
that the OLE DB interface inserts.
- NO
-
replaces null values
that the OLE DB interface inserts with a default value, as specified
in the DEFAULT constraint.