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
