OWNER

CHAR(32)

Name of the owner of the index

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Index name

TYPE

CHAR(6)

Index type (UNIQUE | NULL)

COLUMNNAME

CHAR(32)

Name of the column

SORT

CHAR(4)

Sort sequence for the column (ASC | DESC)

COLUMNNO

FIXED(4)

Number of the column in the index

DATATYPE

CHAR(10)

Data type of the domain (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | LONG | SMALLINT | TIME | TIMESTAMP)

LEN

FIXED(4)

Length or precision of the definition of the column

CREATEDATE

DATE(10)

Creation date of the index

CREATETIME

TIME(8)

Creation time of the index

INDEX_USED

FIXED(10)

Frequency of use in search operations

DISABLED

CHAR(3)

Index not active for search operations (YES | NO)

COMMENT

LONG

Comment on the index