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

Syntax Description

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.

Details

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