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.
