HPE NonStop SQL/MX Error – 3018 An unsigned smallint was expected, not value.

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

Error Message

3018 An unsigned smallint was expected, not value.

Reason for the Error

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

Solution

Replace the value with an unsigned smallint and resubmit