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
