SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-8
SQL 7100
Cause. You attempted a comparison between incompatible data types in a relational,
LIKE, IN or BETWEEN predicate. For example, you cannot compare a numeric value
and a character value.
Effect. The statement does not compile.
Recovery. Check the data types of the operands of the predicate, and correct those
that are incompatible.
SQL 7101
Cause. You specified a value for a column in an INSERT or UPDATE statement that
was incompatible with the data type of the column. For example, you cannot supply a
character string as the value for a numeric column. If the source of the values for an
INSERT operation is a SELECT statement, the data type of each supplied value must
be compatible with the corresponding target column.
Effect. The statement does not compile.
Recovery. Check the data types of values supplied in the value list or SELECT
statement against the data types of the columns in the target table.
SQL 7102
Cause. The select lists of the left SELECT statements contained incompatible data
types.
Effect. The statement does not compile.
Recovery. Check that corresponding elements have the same data types.
7100 Comparisons between value-1 and value-2 data types are
not allowed.
7101 The value for column value-1 has an incompatible value-2
data type.
7102 The data types of the operands value-1 and value-2 of
corresponding elements of a SELECT list union operation are
not compatible.