HPE NonStop SQL/MX Error – 4046 The operands of function name must be exact numeric.

In this blog post, let’s learn about the error message “4046 The operands of function name must be exact numeric.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4046 The operands of function name must be exact numeric.

Reason for the Error

You specified operands of function name that are not type exact numeric, which is required.

Solution

Correct the syntax and resubmit