HPE NonStop SQL/MX Error – 3166 The value specified in the float or double value was less than the minimum allowed or greater than the maximum allowed.

In this blog post, let’s learn about the error message “3166 The value specified in the float or double value was less than the minimum allowed or greater than the maximum allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3166 The value specified in the float or double value was less than the minimum allowed or greater than the maximum allowed.

Reason for the Error

You specified a statement in which you exceed the min or max precision for float or double value.

Solution

Correct the syntax and resubmit