In this post, you’ll learn about the error message -687 field types incomparable in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-687 field types incomparable
Reason for the Error
One column cannot be compared with another column that has incompatible field types.
Solution
Correct the SQL statement.