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

440 Chapter8
Using the Database Utilities
>>REBUILDINDEX
>>REBUILDINDEX
REBUILDINDEX rebuilds the B-Tree index file for a specified dataset that should have an
index file.
When using the ALL option and there is no master dataset, a warning is generated, but
the command is considered to be successful.
The KSAM file built by REBUILDINDEX has the Native Language Support language
specified to match the language of the database, if the key is a text (X or U) data type.
Syntax
>REBUILDI[NDEX] database name [/ maintword ] FOR { ALL
setnamelist
setnumlist 455
}
For example:
REBUILDINDEX ORDERS FOR 3
where ORDERS is the database name , and 3 is set# 3.
Parameters
database name is the name of a TurboIMAGE/XL database.
maintword is the maintenance password.
ALL means all master data sets for the database.
setnamelist is the name of the set list.
setnumlist is the number of the set list.
Example 1
>>REBUILDINDEX ORDERS/secret FOR SalesrepName,Region,District
Example 2
>>REBUILDINDEX ORDERS/secret FOR 3
Rebuilding index for set# 3 (#entries = 18,784, capacity = 21,943)
Done.