SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-7
SQL 4021
Cause. You specified a select list that contains a nongrouping, nonaggregated column
name, which is not supported.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4022
Cause. You specified column name more than once.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4023
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
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.
4021 The select list contains a nongrouping non-aggregated
column, name.
4022 Target column name was specified more than once.
4023 The degree of each row value constructor (value) must
equal the degree of the target table column list (value).
4024 Column name has no default value, so it must be
explicitly specified in the insert column list.