Start of change

-602   TOO MANY COLUMNS, PERIODS, OR KEY-EXPRESSIONS SPECIFIED IN A CREATE INDEX OR ALTER INDEX STATEMENT

Explanation

One of the following specifications in a CREATE INDEX or ALTER INDEX statement exceeds the permitted maximum value of 64:

  • The sum of the number of columns and twice the number of identified periods:
    columns + (2
    ×
     periods)
  • The number of key-expressions.

System action

The statement cannot be processed.

Programmer response

Modify the index definition to conform to the system-imposed column or key-expression limit of 64.

SQLSTATE

54008

End of change