Data Set Options for Relational Databases |
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 |
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.