HPE NonStop SQL/MX Error – 3431 For a table with a single column that is an IDENTITY column, col-name,the tuple list cannot have only DEFAULT values. Specify values for all.

In this blog post, let’s learn about the error message “3431 For a table with a single column that is an IDENTITY column, col-name,the tuple list cannot have only DEFAULT values. Specify values for all.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3431 For a table with a single column that is an IDENTITY column, col-name,the tuple list cannot have only DEFAULT values. Specify values for all.

Reason for the Error

For an INSERT operation, DEFAULT values are specified for a table with one IDENTITY column.

Solution

Specify the input values for the IDENTITY column and resubmit the INSERT statement