In this post, you’ll learn about the error message -686 column defined with a field procedure can not compare with another column with different field procedure in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-686 column defined with a field procedure can not compare with another column with different field procedure
Reason for the Error
The columns specified are not compatible.� Different field procedures are specified, or only one field procedure is specified.
Solution
Correct the SQL statement.