SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-11
SQL 7118
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Check that the two collations do not result in a collation that conflicts with
the result of the operation.
SQL 7120
Cause. The two operands of the binary arithmetic operator did not belong to data type
classes that can be operated upon.
Effect. The statement does not compile.
Recovery. Check that the operands belong to data type classes that can be operated
upon in a binary arithmetic expression.
SQL 7121
Effect. You attempted a negation operation on an operand that does not have a
NUMERIC or INTERVAL data type.
Effect. The statement does not compile.
Recovery. Check that the operand belongs to a data type class that can be negated.
SQL 7122
Cause. The operand for a unit specifier did not have a numeric, INTERVAL, or date-
time data type. You cannot use a unit specifier for a character data type.
Effect. The statement does not compile.
Recovery. Check that the operand has a numeric, date-time, or INTERVAL data type.
7118 The collation specified on the SELECT list index in the
GROUP BY or ORDER BY clause is not compatible with the
collation specified on the corresponding select list entry.
7120 An invalid arithmetic operation was attempted between
value-1 and value-2 data types.
7121 Negation is not allowed on a value-1 data type.
7122 The operand of the unit specifier does not have a
numeric, INTERVAL, or date-time (DATE, TIME, TIMESTAMP, or
DATETIME) data type.