HPE NonStop SQL/MX Error – 3016 Precision of decimal, value, cannot exceed 18.

In this blog post, let’s learn about the error message “3016 Precision of decimal, value, cannot exceed 18.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3016 Precision of decimal, value, cannot exceed 18.

Reason for the Error

You gave a decimal item, value, with precision greater than 18, which is not supported.

Solution

Redefine the item with a precision value of 18 or less