-678   THE CONSTANT constant SPECIFIED FOR THE INDEX LIMIT KEY MUST CONFORM TO THE DATA TYPE data-type OF THE CORRESPONDING COLUMN column-name

Explanation

The index limit key value constant has been specified incorrectly in the CREATE INDEX or ALTER INDEX statement.

Limit key value specifications must conform to the data type of the corresponding index key column. In this case, constant must be of data type data-type to conform to the data type of column column-name.

System action

The statement cannot be processed. The index was not created.

Programmer response

Correct the statement so that each limit key value constant is of precisely the same data type as that of the corresponding index key column.

SQLSTATE

53045