Previous Page | Next Page

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.


See Also

To apply this option to an individual data set, see the BL_KEEPIDENTITY= Data Set Option.

Previous Page | Next Page | Top of Page