Data Set Options for Relational Databases |
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 |
specifies that the user must provide values for the identity column.
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.