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

BL_KEEPNULLS=YES | NO

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.