In this blog post, let’s learn about the error message “1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column, col-name, for the table, table-name, is not allowed with NO SELECT.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column, col-name, for the table, table-name, is not allowed with NO SELECT.
Reason for the Error
The NO SELECT syntax with the default specification type of GENERATED ALWAYS AS IDENTITY is not allowed.
Solution
Remove the NO SELECT syntax and resubmit the statement
