HPE NonStop SQL/MX Error – 1575 The INCREMENT BY value cannot be greater than the MAXVALUE for col-name.

Data 10 Views 1 Min Read

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

Tags: