DB2 Error Code – -402 an arithmetic function or operator arith-fop is applied to character or datetime data

In this post, you’ll learn about the error message -402 an arithmetic function or operator arith-fop is applied to character or datetime data in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-402 an arithmetic function or operator arith-fop is applied to character or datetime data

Reason for the Error

A nonnumeric operand has been specified for the arithmetic function or operator ‘arith-fop’.

Solution

Examine and correct the syntax of the SQL statement such that all operands of the specified function or operator are numeric.