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.
Valid in: SAS/ACCESS LIBNAME statement
Default: NO
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: OLE DB
See: BL_KEEPIDENTITY= data set option, BULKLOAD= LIBNAME option

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.