Data Set Options for Relational Databases |
Indicates which scheme the DB2 load utility should use for index
maintenance.
Default value: |
AUTOSELECT
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
DB2 under UNIX and PC Hosts
|
BL_INDEXING_MODE=AUTOSELECT | REBUILD | INCREMENTAL
| DEFERRED
|
-
AUTOSELECT
-
The load utility automatically decides between
REBUILD or INCREMENTAL mode.
-
REBUILD
-
All indexes are rebuilt.
-
INCREMENTAL
-
Indexes are extended with new data
-
DEFERRED
-
The load utility does not attempt index
creation if this mode is specified. Indexes are marked as needing a refresh.
To specify this option, you must first set BULKLOAD=YES.
For more information about using the values for this
option, see the IBM DB2 Universal Database Data Movement Utilities Guide
and
Reference.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.