HPE NonStop SQL/MX Error – 1592 Only the MAXVALUE or INCREMENT BY option can be altered for the col-name.

Data 24 Views 1 Min Read

In this blog post, let’s learn about the error message “1592 Only the MAXVALUE or INCREMENT BY option can be altered for the col-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1592 Only the MAXVALUE or INCREMENT BY option can be altered for the col-name.

Reason for the Error

The internal sequence generator option specified cannot be altered. Only MAXVALUE and INCREMENT BY options are altered.

Solution

Specify either the MAXVALUE or INCREMENT BY internal sequence generator options, and resubmit the statement

Tags: