DB2 Error Code – -678 the literal literal specified for the index limit key must conform to the data type data type of the corresponding column column name

In this post, you’ll learn about the error message -678 the literal literal specified for the index limit key must conform to the data type data type of the corresponding column column name in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-678 the literal literal specified for the index limit key must conform to the data type data type of the corresponding column column name

Reason for the Error

The index limit key value ‘literal’ has been specified incorrectly in the CREATE INDEX statement. Limit key value specifications must conform to the data type of the corresponding index key column.� In this case, the ‘literal’ must be of data type ‘data type’ to conform to the data type of column ‘column name’.

Solution

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