HPE NonStop SQL/MX Error – 1593 Only one col-nameoption can be altered at a time.

In this blog post, let’s learn about the error message “1593 Only one col-nameoption can be altered at a time.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1593 Only one col-nameoption can be altered at a time.

Reason for the Error

For an IDENTITY column, more than one internal sequence generator option is specified for an ALTER operation.

Solution

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