Neoview Messages Manual (R2.2)

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.
129