Directives

DROP INDEX

Drop Key from Keyed File

Format

DROP INDEX {keynumber | keyname$} FROM filename$ [,ERR=stmtref]

filename$	Name of the file from which the key will be dropped. String expression.
FROM	Mandatory keyword, not case sensitive.
keyname$	Name of the key to drop (if assigned). String expression.
keynumber	Key number (KNO value) to drop.
stmtref	Program line number or statement label to which to transfer control.

The DROP INDEX directive drops keys from a PxPlus Keyed file without having to rebuild the file.

When dropping keys from a file:

The key is removed from the data file and the space previously occupied by the key table is made available for subsequent use within the file.
Only one drop can be processed against a file at one time.
Exclusive access to the file is required.
The primary key is required and cannot be dropped.

drop index 3 from "cstfile"
drop index CustName from "cstfile"