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.
| Valid in: |
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
|
| Default: |
LIBNAME setting |
| Restriction: |
This option is valid only when you use the Microsoft
SQL Server provider.
|
| Requirement: |
To specify this option, you must first set BULKLOAD=YES. |
| Data source: |
OLE DB |
| See: |
BL_KEEPIDENTITY= LIBNAME
option, BULKLOAD= data set option |
Syntax
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.