Environment Catalog Syntax

Index Section

INDEX index_name
TYPE index_type_spec
AS column_spec [, column_spec...]
[PHYSICAL "native_index"]

INDEX index_name

[[environment_name.]database_name.]index_name

index_ name represents a non-ambiguous index or view.

index_name MUST BEGIN WITH A LETTER, A-Z (case insensitive) and may contain up to 32 characters including letters, numbers and allowed special characters.

If index_name contains any reserved words or allowed special characters, it must be enclosed in single or double quotes.

TYPE index_type_spec

Required when declaring an INDEX index and can declare any one of these values:

• [{NATIVE | OMNIDEX}] INVERTED
• [NATIVE] HASHED
• [{NATIVE | OMNIDEX}] SORTED
• [NATIVE] LINKED LIST

AS column_spec [, column_spec...]

Required when declaring an INDEX index. This string, up to 32 characters long, uniquely identifies the column defined within the Environment to which the native index corresponds.

PHYSICAL "native_index"

Optional. This is a quoted string of up to 255 characters which references the underlying database's native name for the index.

For RMS, ISAM, and C-ISAM, PHYSICAL "native_index" is a zero-relative sequenced number that specifies RMS, ISAM, and C-ISAM key numbers that are greater than zero (0), up to the limit allowed by the file management system.

top