HPE NonStop SQL/MX Error – 3037 Precision of type data type cannot exceed 18.

In this blog post, let’s learn about the error message “3037 Precision of type data type 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

3037 Precision of type data type cannot exceed 18.

Reason for the Error

You specified a CREATE TABLE statement with a precision value greater than 18 for data type, which is not supported.

Solution

Correct the syntax and resubmit