In this blog post, let’s learn about the error message “1590 Column col-name is not an IDENTITY column.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1590 Column col-name is not an IDENTITY column.
Reason for the Error
Specified column name for ALTER operation is not an IDENTITY column.
Solution
Correct the IDENTITY column name, and resubmit the statement