iX V6.5 (30391-90011)

428 Chapter8

Using the Database Utilities

>>DROPINDEX

The DROPINDEX command drops the associated B-Tree index ﬁle and updates the root ﬁle.

When using the ALL option and there is no master dataset, a warning is generated, but

the command is considered to be successful.

Syntax

>>DROPI[NDEX]

database name

maintword

] FOR { ALL

setnamelist

setnumlist

}

For example:

>>DROPINDEX ORDERS FOR 2

where ORDERS is the

database name

and 2 is set# 2.

Parameters

database name

is the name of a TurboIMAGE/XL database.

maintword

is the maintenance password.

setnamelist

is the name of the set list.

setnumlist

is the number of the set list.

ALL means all master data sets for the database.

Example

>>DROPINDEX ORDERS/secret FOR 2

Dropping index from set# 2 (#entries = 84,164, capacity = 188,517)

Done.