HPE NonStop SQL/MX Error – 1601 Recalibration of the GENERATED ALWAYS AS IDENTITY column, col-name, for the table, table-name, is not allowed with NO SELECT.

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