In this post, you’ll learn about the error message -401 the operands of an arithmetic or comparison operation are not comparable in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-401 the operands of an arithmetic or comparison operation are not comparable
Reason for the Error
An arithmetic operation appearing within the SQL statement has a mixture of numeric and nonnumeric operands, or the operands of a comparison operation are not compatible.
Solution
Check the data types of all operands to ensure that their data types are comparable and compatible with their usage in the statement.� If all the operands of the SQL statement are correct, then, if a view is being accessed, check the data types of all the operands in the view definition.
