HPE NonStop SQL/MX Error – 3021 An unsigned number was expected as the second operand within parentheses, not value.

In this blog post, let’s learn about the error message “3021 An unsigned number was expected as the second operand within parentheses, not value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3021 An unsigned number was expected as the second operand within parentheses, not value.

Reason for the Error

You specified an unexpected value, value. NonStop SQL/MX requires an unsigned number.

Solution

Replace the value with an unsigned number and resubmit