In this post, you’ll learn about the DB2 error -401-SQL0401N The data types of the operands for the operation “>=” are not compatible. and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
-401 – SQL0401N The data types of the operands for the operation “>=” are not compatible.
Reason for the Error & Solution
A mathematical comparison query was attempted on a field whose mapping was to a non-numeric field, such as VARCHAR. DB2 disallows such queries.