SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
5-57
Recovery. 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.
SQL 3431
Where col-name is the IDENTITY column name.
Cause. For an INSERT operation, DEFAULT values are specified for a table with one
IDENTITY column.
Effect. The operation fails.
Recovery. Specify the input values for the IDENTITY column and resubmit the
INSERT statement.
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.