BL_INDEXING_MODE= Data Set Option

Indicates which scheme the DB2 load utility should use for index maintenance.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: AUTOSELECT
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: DB2 under UNIX and PC Hosts
See: BULKLOAD= data set option
Syntax
Details

Syntax

BL_INDEXING_MODE=AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED

Syntax Description

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.

Details

For more information about using the values for this option, see the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.
Copyright © SAS Institute Inc. All rights reserved.