SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
5-57
SQL 3426
Cause. A host variable is used in the WHERE clause of a multi commit statement.
Effect. The operation fails.
Recovery. Do not use a host variable or a dynamic parameter in the WHERE clause
of a multi commit statement.
SQL 3427
Where option is the duplicate internal sequence generator option.
Where col-name is the IDENTITY column name.
Cause. You specified a duplicate sequence generator option.
Effect. The operation fails.
Recovery. Remove the duplicate option and resubmit the statement.
SQL 3428
Where col-name is the IDENTITY column name.
Cause. For an INSERT operation, input value is specified for the GENERATED
ALWAYS AS IDENTITY type IDENTITY column.
Effect. The operation fails.
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.
3426 Dynamic parameters and host variables are not allowed in
the WHERE clause of multi commit statements.
3427 Duplicate option options were specified for the col-
name.
3428 IDENTITY column col-name defined as GENERATED ALWAYS
cannot accept values specified by the user.
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.