SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-3
SQL 7010
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Check that the numeric value or column used is exact with a scale of 0.
SQL 7011
Cause. The expression had operands that did not have the same range of DATETIME
fields.
Effect. The statement does not compile.
Recovery. Consider using the date-time EXTEND function to make the range of
DATETIME fields identical.
SQL 7012
Cause. The expression had operands that did not belong to the same INTERVAL
class. The two INTERVAL operands must both belong to either the year-month class or
the day-fraction class.
Effect. The statement does not compile.
Recovery. Check that both INTERVAL operands are in either the year-month class or
the day-time class.
7010 The numeric value or column used in this expression is
either not exact or it does not have a scale of zero (0).
7011 The two date-time (DATE, TIME, TIMESTAMP, or DATETIME)
operands in this arithmetic or relational expression do not
have the same range of DATETIME fields.
7012 An invalid arithmetic operation is performed between
INTERVAL operands belonging to different INTERVAL classes.