Data Set Options for Relational Databases BL_KEEPIDENTITY= Data Set Option 155
BL_INDEXING_MODE= Data Set Option
Used to indicate which scheme the DB2 load utility should use with respect to index maintenance
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC
Default value:
AUTOSELECT
Syntax
BL_INDEXING_MODE= AUTOSELECT | REBUILD | INCREMENTAL |
DEFERRED
Syntax Description
AUTOSELECT
The load utility will automatically decide between REBUILD or INCREMENTAL
mode. This is the default.
REBUILD
All indexes will be rebuilt.
INCREMENTAL
Indexes will be extended with new data
DEFERRED
The load utility will not attempt index creation if this mode is speciļ¬ed. Indexes will
be marked as needing a refresh.
See Also
For more information on the usage of these values, see the DB2 Data Movement
Utilities Guide and Reference.
BL_KEEPIDENTITY= Data Set Option
Determines whether the identity column that is created during a bulk load is populated with values
generated by SQL Server or with values provided by the user
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: OLE DB
Default value: LIBNAME setting
Syntax
BL_KEEPIDENTITY= YES | NO
