TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

496 Chapter11
B-Tree Indices
External Commands and Utilities Affected
Example
NAME: Employeename, MANUAL /INDEXED(10,20/30);
DBUTIL
DBUTIL has three new commands:
• ADDINDEX
• DROPINDEX
• REBUILDINDEX
Syntax for ADDINDEX
ADDI[NDEX]
database name [/ maintword ] FOR { ALL
setnamelist
setnumlist
}
Syntax for DROPINDEX
DROPI[NDEX] database name [/ maintword ] FOR { ALL
setnamelist
setnumlist
}
Syntax for REBUILDINDEX
REBUILDI[NDEX] database name [/ maintword ] FOR { ALL
setnamelist
setnumlist
}
Parameters
setnamelist is the list setname [,...]
setnumlist is the list setnum [,...]
ALL means all master data sets for the database.
Examples
>>ADDINDEX ORDERS/secret for ALL
>>DROPINDEX ORDERS/secret for 1,7
>>REBUILDINDEX ORDERS/secret FOR SalesrepName,Region,District
Discussion
The ADDINDEX command adds the associated B-Tree index file and updates the root file.
The DROPINDEX command drops the associated B-Tree index file and updates the root file.
REBUILDINDEX rebuilds the index file for a master data set that has an index file.
The KSAM file has the Native Language Support language specified to match the