SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-9
SQL 4035
Cause. In a CREATE TABLE statement, the PRIMARY KEY or CLUSTERING KEY
clause included a column that did not appear in the list of columns for the table. The
key column was either misspelled or omitted from the columns in the table's definition.
Effect. The statement fails.
Recovery. Specify the key columns from the column list for the table.
SQL 4036
Cause. The search condition in a CREATE CONSTRAINT statement contained a
subquery.
Effect. The statement does not compile.
Recovery. No recovery is necessary. This feature is not supported.
SQL 4037
Cause. The search condition in a CREATE CONSTRAINT statement contained an
aggregate function.
Effect. The statement does not compile.
Recovery. No recovery is necessary. This feature is not supported.
SQL 4038
Cause. The query expression in a protection view definition or a cursor definition with
the FOR UPDATE clause contained an aggregate function.
Effect. The statement fails.
Recovery. Use either a shorthand view or a cursor whose declaration omits the FOR
UPDATE clause.
4035 Key column value-1 is not in the list of columns defined
for the table.
4036 A constraint definition cannot contain a subquery.
4037 A constraint definition cannot contain aggregate
functions.
4038 A protection view or cursor definition used for update
cannot contain aggregate functions.