HP Neoview Messages, Manual

Page: 135 / 400

SQL 4023
4023 The degree of each row value constructor (value) must equal the
degree of the target table column list (value).
Cause
You specified a statement, such as INSERT, in which a
row value
constructor does
not equal the degree of the target table column list. For example:
INSERT INTO table (acol, bcol) VALUES (1, 2, 3);
is wrong because the number of columns does not match the number of values.
Effect The operation fails.
Recovery Correct the syntax and resubmit.
SQL 4024
4024 Column name has no default value, so it must be explicitly specified
in the insert column list.
Cause You attempted to insert column
name
into a table, and the column has no default
value. For example:
INSERT INTO table (acol, bcol, ccol) VALUES (1, 2);
is wrong if
ccol
does not have a default value and you did not specify its value. The column
list is optional, but if you use it, you must explicitly specify values for columns that do not
have default values.
Effect The operation fails.
Recovery
Correct the syntax and resubmit.
SQL 4025
4025 Error while preparing constraint name on table table name.
table name
is the name of the table.
Cause
The HP Neoview database software received an error while preparing constraint
name
on
table name
. See accompanying error messages.
Effect The operation fails.
Recovery
Correct the syntax and resubmit.
SQL 4026
4026 Reading from and inserting into, or updating in, or deleting from
the same table, name, is not currently supported.
name
is the name of the table.
Cause You attempted to read from and insert, update, or delete within the same table
name
.
This feature is not supported.
Effect
The operation fails.
Recovery Correct the syntax and resubmit.
SQL 4027
4027 Table or view name does not permit insertions.
name
is the name of the table.
Cause You attempted to insert into table
name
, which is not insertable.
Effect The operation fails.
Recovery None.
135