In this blog post, let’s learn about the error message “3008 The specified precision, precision, for a DECIMAL UNSIGNED data type exceeds the maximum supported precision of 9.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3008 The specified precision, precision, for a DECIMAL UNSIGNED data type exceeds the maximum supported precision of 9.
Reason for the Error
You specified a statement with a precision value greater than nine for the PRECISION field of a DECIMAL UNSIGNED column, which is not supported.
Solution
Correct the syntax and resubmit