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
