SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-9
SQL 7103
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Use a host variable whose data type is compatible with that of the select
list entry.
SQL 7110
Cause. You specified a comparison, LIKE, IN, or BETWEEN predicate that attempted
to compare values with data types that belong to incompatible character sets. For
example, you cannot compare a KANJI value to an UNKNOWN value. The two
operands being compared must have the same character set.
Effect. The statement does not compile.
Recovery. Check the character sets of the operands of the predicate and correct
those that are incompatible.
SQL 7111
Cause. The character set for a value specified for a column in an INSERT or UPDATE
statement was not compatible with the character set of the column. For example, a
KANJI value was supplied for a BIG5 column. If the source of the values for an
INSERT operation is a SELECT statement, the character set for each specified value
must be compatible with the corresponding target column.
Effect. The statement does not compile.
Recovery. Check that the character set of each value in the value list or SELECT
statement matches the character set of the column in the target table.
7103 The data type of the host variable value-1 is not
compatible with the value-2 data type of the corresponding
SELECT list entry.
7110 Comparisons between value-1 and value-2 character sets
are not allowed.
7111 Character set value-1 of the value for column value-2 is
not compatible with character set value-3 of the column.