Previous Page | Next Page

Data Set Options for Relational Databases

BL_KEEPNULLS= Data Set Option



Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during bulk load.
Default value: LIBNAME setting
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: OLE DB

Syntax
Syntax Description
Details
See Also

Syntax

BL_KEEPNULLS=YES | NO

Syntax Description

YES

preserves NULL values inserted by the OLE DB interface.

NO

replaces NULL values that are inserted by the OLE DB interface with a default value (as specified in the DEFAULT constraint).


Details

To specify this option, you must first set BULKLOAD=YES.

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


See Also

To assign this option to a group of relational DBMS tables or views, see the BL_KEEPNULLS= LIBNAME Option.

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page