HPE NonStop SQL/MX Error – 3043 Precision greater than 18 for a COMP numeric type is not valid.

In this blog post, let’s learn about the error message “3043 Precision greater than 18 for a COMP numeric type is not valid.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3043 Precision greater than 18 for a COMP numeric type is not valid.

Reason for the Error

You specified a precision value greater than 18 for a COMP numeric type, which is not supported.

Solution

Change the precision to a value of 18 or less and resubmit