TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

Chapter 8 423
Using the Database Utilities
>>ADDINDEX
>>ADDINDEX
The ADDINDEX command updates the root file, and adds the associated B-Tree 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.
Syntax
>>ADDI[NDEX] database name [/ maintword ] FOR { ALL
setnamelist
setnumlist
}
For example:
>>ADDINDEX ORDERS FOR ALL
where ORDERS is the database name .
Parameters
database name is the name of a TurboIMAGE database.
maintword is the maintenance password.
setnamelist is the list setname [,...]
setnumlist is the list setnum [,...]
ALL means all master data sets for the database.
Example
>>ADDINDEX ORDERS/secret FOR ALL
Found 4 master datasets.
Adding index to set# 1 (#entries = 162,730, capacity = 218,987)
Adding index to set# 2 (#entries = 84,164, capacity = 188,517)
Adding index to set# 3 (#entries = 18,784, capacity = 21,943)
Adding index to set# 4 (#entries = 783, capacity = 2583)
Done.
If the data set is big and DBUTIL is interactive, a progress report at an interval of every 5%
will be displayed.
5% done ...
10% done ...
It is always displayed on the same line. It will be overwritten by the next permanent line.
Adding index to ... or Done.