HPE NonStop SQL/MX Error – 3428 IDENTITY column col-name defined as GENERATED ALWAYS cannot accept values specified by the user.

Data 32 Views 1 Min Read

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

Tags: