The LIBNAME Statement for Relational Databases BL_KEEPNULLS= LIBNAME Option 71
BL_KEEPIDENTITY= LIBNAME Option
Determines whether the identity column that is created during bulk loading is populated with
values generated by Microsoft SQL Ser ver or with values provided by the user
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
OLE DB
Default value:
NO
Syntax
BL_KEEPIDENTITY= YES | NO
Syntax Description
YES
specifies that the user must provide values for the identity column.
NO
specifies that Microsoft SQL Server generates values for an identity column in the
table.
Details
This option is only valid when you use the Microsoft SQL Server provider.
See Also
To apply this option to an individual data set, see the data set option
“BL_KEEPIDENTITY= Data Set Option” on page 155.
BL_KEEPNULLS= LIBNAME Option
Indicates how NULL values in Microsoft SQL Server columns that accept NULL are handled during
bulk loading
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
OLE DB
Default value: YES
Syntax
BL_KEEPNULLS= YES | NO
Syntax Description
