SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-10
SQL 7112
Cause. The select lists of the left SELECT statements have incompatible character
sets.
Effect. The statement does not compile.
Recovery. Make sure that the corresponding elements have the same character sets.
SQL 7113
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Specify a host variable whose character set is the same as that of the
corresponding select list entry.
SQL 7116
Cause. You specified two operands for a comparison, LIKE, IN, or BETWEEN
predicate that have conflicting collating sequences.
Effect. The statement does not compile.
Recovery. Do not use different collations for the two operands. Use the same or
compatible collations for the two operands.
SQL 7117
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Check that corresponding elements do not result in a collation that conflicts
with the result of the operation.
7112 The character sets of the operands value-1 and value-2
of the corresponding elements of the SELECT list union
operation are not compatible.
7113 The character set value-1 of the select list entry is
not compatible with the character set value-3 of the host
variable value-2.
7116 Two operands being compared have incompatible
collations.
7117 The collations used on corresponding elements of the
SELECT lists for a union operation are not compatible.