Data Set Options for Relational Databases |
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
|
-
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.
To specify this option, you must first set BULKLOAD=YES.
This option is valid only when you use the Microsoft
SQL Server provider.
To assign this option to a group of relational
DBMS tables or views, see the
BL_KEEPIDENTITY= LIBNAME Option.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.