In this blog post, let’s learn about the error message “1575 The INCREMENT BY value cannot be greater than the MAXVALUE for col-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1575 The INCREMENT BY value cannot be greater than the MAXVALUE for col-name.
Reason for the Error
The INCREMENT BY internal sequence generator option value specified was greater than MAXVALUE.
Solution
Specify an INCREMENT BY option value less than MAXVALUE, and resubmit the statement
