HP Neoview Messages, Руководство пользователя

Страница: 128 / 400

SQL 3425
3425 Embedded embedded-operation expression is not supported with Long
Running Updates.
embedded-operation
is an embedded INSERT, UPDATE or DELETE. statement.
Cause
A MULTI COMMIT option has been specified on an embedded statement.
Effect
The statement fails to execute and the transaction options do not take affect.
Recovery
Use MULTI COMMIT ON only with non-embedded DELETE statement.
SQL 3426
3426 Dynamic parameters and Host variables are not allowed in the WHERE
clause of Long Running Updates.
Cause
You specified a Dynamic parameter or Host variable in the WHERE clause of a Long
Running Update statement.
Effect The statement fails to execute.
Recovery
Do not use Dynamic parameter or Host variable in the WHERE clause of the Long
Running Update statement.
SQL 3427
3427 Duplicate seq-gen-option options were specified for the col-name.
seq-gen-option
is the sequence generator option that was duplicated.
col-name
is the name of the IDENTITY column.
Cause
You specified a duplicate sequence generator option. A second START WITH,
MINVALUE, MAXVALUE, INCREMENT BY or NO CYCLE sequence generator option has
been specified.
Effect The statement fails.
Recovery Specify a single START WITH, MINVALUE, MAXVALUE, INCREMENT BY or
NO CYCLE sequence generator option, and resubmit the statement.
SQL 3428
3428 Identity column col-name defined as GENERATED ALWAYS cannot accept
values specified by the user.
col-name
is the name of the IDENTITY column.
Cause For an INSERT operation, you specified an input value for the IDENTITY column.
Effect The statement fails.
Recovery
When the IDENTITY column type is GENERATED ALWAYS AS IDENTITY, the
system always provides the value for the IDENTITY column. The INSERT should be resubmitted
to allow the default characteristics of the column to generate the value of the IDENTITY column
internally.
SQL 3431
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.
col-name
is the name of the IDENTITY column.
Cause
For an INSERT operation, you specified DEFAULT values for a table with a single
column that is an IDENTITY column.
Effect The statement fails.
128 Parser and Compilation Messages (3000 Through 3999)