The LIBNAME Statement for Relational Databases |
Indicates how NULL values in Microsoft SQL Server columns that
accept NULL are handled during bulk loading.
Default value: |
YES
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
OLE DB
|
-
YES
-
specifies that Microsoft SQL Server preserves
NULL values inserted by the OLE DB interface.
-
NO
-
specifies that Microsoft SQL Server replaces
NULL values that are inserted by the OLE DB interface with a default value
(as specified in the DEFAULT constraint).
This option only affects values in Microsoft
SQL Server columns that accept NULL and have a DEFAULT constraint.
To apply this option to an individual data set, see
the BL_KEEPNULLS= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.