Index Manipulation Language

These commands and functions perform operations on and return information about index files.

Use	To
ATAGINFO( ) Function	Create an array that contains information about index files for the selected table.
CANDIDATE( ) Function	Specify if an index tag is a candidate index tag.
CDX( ) Function	Return the name of the open compound index file that has the specified index position.
CLOSE Commands	Close various file types.
COPY INDEXES Command	Create compound index tags from single-entry .idx index files.
COPY TAG Command	Create a single-entry index (.idx) file from a tag in a compound index file.
DESCENDING( ) Function	Determine if an index was created with the DESCENDING keyword.
DELETE TAG Command	Remove a tag from a compound index file.
FOR( ) Function	Return an index filter expression.
IDXCOLLATE( ) Function	Return the collating sequence for an index or index tag.
INDEX Command	Create an index file.
INDEXSEEK( ) Function	Search and indexed table without moving the record pointer.
KEY( ) Function	Return the index key expression for an index tag or index file.
KEYMATCH( ) Function	Search an index tag or index file for an index key.
MDX( ) Function	Return the name of the open compound index file that has the specified index position number.
NDX( ) Function	Return the name of an open index (.IDX) file for the current or specified table.
ORDER( ) Function	Return the name of the controlling index file or tag
PRIMARY( ) Function	Determine if an index tag is the primary index tag.
REINDEX Command	Rebuild open index files.
SET COLLATE Command	Specify a collation sequence for character fields in indexing and sorting operations.
SET INDEX Command	Open one or more index files for use with the current table.
SET KEY Command	Specify access to a range of records based on their index keys.
SET ORDER Command	Designate a controlling index file or tag for a table.
SET UNIQUE Command	Specify whether records with duplicate index key values are maintained in an index file.
SYS(14) - Index Expression	Return the index expressions from indexes.
SYS(21) - Controlling Index Number	Return the index position for the current selected work area.
SYS(2021) - Filtered Index Expression	Return a filter expression from an index.
TAG( ) Function	Return a tag name from an open compound index file or the name from an open single-entry index file.
TAGCOUNT( ) Function	Return the number of open indexes.
TAGNO( ) Function	Return the index position for an index file.

See Also

Other Resources

Databases

Language Categories