The LIBNAME Statement for Relational Databases

BL_KEEPIDENTITY= LIBNAME Option

Determines whether the identity column that is created during bulk loading is populated with values that Microsoft SQL Server generates or with values that the user provides.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	OLE DB

Syntax
Syntax Description
Details
See Also

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 valid only when you use the Microsoft SQL Server provider.