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.