SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-21
SQL 4086
Cause. The select lists of the left SELECT statements involved in the UNION
operation did not have the same number of elements.
Effect. The statement does not compile.
Recovery. Check that the number of elements is the same in each select list.
SQL 4089
Cause. The value list specified for the INSERT statement referred to one or more
column names. A column name cannot be in an expression or listed as a single value
in an INSERT statement.
Effect. The statement does not compile.
Recovery. Remove any column names from the value list of an INSERT statement.
SQL 4092
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Declare the column with DEFAULT NULL or do not assign NULL value to
the column.
SQL 4093
Cause. If DEFAULT NULL was explicitly specified, the column cannot be used as a
key column.
Effect. The statement fails.
Recovery. Either do not specify DEFAULT NULL or do not use the column for a key.
4086 The select list of the UNION operands must have the same
number of elements.
4089 The value list of the INSERT statement cannot reference
a column.
4092 NULL value can only be assigned to columns that can
contain null values.
4093 DEFAULT NULL is specified for a column that is being
used as a KEY.