In this blog post, let’s learn about the error message “3428 IDENTITY column col-name defined as GENERATED ALWAYS cannot accept values specified by the user.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3428 IDENTITY column col-name defined as GENERATED ALWAYS cannot accept values specified by the user.
Reason for the Error
For an INSERT operation, input value is specified for the GENERATED ALWAYS AS IDENTITY type IDENTITY column.
Solution
For GENERATED ALWAYS AS IDENTITY type IDENTITY column, value is generated for the IDENTITY column. Resubmit the INSERT statement to allow the default characteristics of the column to generate the value internally
