HPE NonStop SQL/MX Error – 1595 The MAXVALUE option for the IDENTITY column col-namemust be a valid numeric value.NO MAXVALUE is not allowed.

In this blog post, let’s learn about the error message “1595 The MAXVALUE option for the IDENTITY column col-namemust be a valid numeric value.NO MAXVALUE is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1595 The MAXVALUE option for the IDENTITY column col-namemust be a valid numeric value.NO MAXVALUE is not allowed.

Reason for the Error

An unsupported option (NO MAXVALUE) is specified for an ALTER operation.

Solution

Specify a valid numeric value for the MAXVALUE option and resubmit the statement