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
