In this blog post, let’s learn about the error message “4038 The operand of an AVG or SUM function must be numeric or interval.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4038 The operand of an AVG or SUM function must be numeric or interval.
Reason for the Error
You attempted to perform an AVG or SUM function with an invalid operand. It must be numeric or interval.
Solution
Correct the syntax and resubmit