HPE NonStop SQL/MX Error – 4077 Function name accepts only one or two operands.

In this blog post, let’s learn about the error message “4077 Function name accepts only one or two operands.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4077 Function name accepts only one or two operands.

Reason for the Error

You specified an invalid argument in function name. This function accepts only one or two arguments, both numeric.

Solution

Correct the syntax and resubmit