HPE NonStop SQL/MX Error – 4038 The operand of an AVG or SUM function must be numeric or interval.

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