BL_KEEPNULLS= LIBNAME Option

Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk loading.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	YES
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	OLE DB
See:	BL_KEEPNULLS= data set option, BULKLOAD= LIBNAME option

Syntax

BL_KEEPNULLS=YES | NO

YES: specifies that Microsoft SQL Server preserves NULL values that the OLE DB interface inserts.

NO: specifies that Microsoft SQL Server replaces NULL values that the OLE DB interface inserts with a default value, as specified in the DEFAULT constraint.

This option affects values in only Microsoft SQL Server columns that accept NULL and have a DEFAULT constraint.