Data Set Options for Relational Databases |
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
|
-
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).
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.
To assign this option to a group of
relational
DBMS tables or views, see the
BL_KEEPNULLS= LIBNAME Option.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.