Previous Page | Next Page

Data Set Options for Relational Databases

BL_KEEPIDENTITY= Data Set Option



Determines whether the identity column that is created during bulk load is populated with values that Microsoft SQL Server generates or with values that the user provides.
Default value: LIBNAME setting
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
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 the Microsoft SQL Server generates values for an identity column in the table.


Details

To specify this option, you must first set BULKLOAD=YES.

This option is valid only when you use the Microsoft SQL Server provider.


See Also

To assign this option to a group of relational DBMS tables or views, see the BL_KEEPIDENTITY= LIBNAME Option.

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page