Directives

DROP INDEX

Drop Key from Keyed File

Format

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

filespec	Can be a numeric expression indicating the open channel number to use or a string expression containing the pathname of the file from which the key will be dropped. If using the file channel, it must be to a keyed or memory file, and if it is a keyed file, the channel must be locked.
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.

(Support for using a file channel was added in PxPlus 2023 Update 1.)

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"