156 BL_KEEPNULLS= Data Set Option Chapter 10
Syntax Description
YES
specifies that the user must provide values for the identity column.
NO
specifies that the SQL Server generates values for an identity column in the table.
Details
This option is only valid when you use the SQL Server provider.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “BL_KEEPIDENTITY= LIBNAME Option” on page 71.
BL_KEEPNULLS= Data Set Option
Indicates how NULL values in SQL Server columns that accept NULL are handled during a bulk load
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
OLE DB
Default value:
LIBNAME setting
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
This options only affects values in 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
LIBNAME option “BL_KEEPNULLS= LIBNAME Option” on page 71.
