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(22) - Controlling Tag or Index Name

Returns the name of the master controlling .cdx compound index tag or .idx index file for a table.

SYS(2021) - Filtered Index Expression

Returns the filter expression for an open single-entry index (.idx) file or filter expressions for tags in compound index (.cdx) files.

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.

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic