SQL/MP Messages Manual

SQL Compiler Generator Messages (7000 to 7999)
HP NonStop SQL/MP Messages Manual—427720-006
9-5
SQL 7016
Cause. Stated in the error message.
Effect. The constraint or protection view is not created.
Recovery. Check that an element that needs a date-time value in local civil time was
not used in a constraint or protection view expression.
SQL 7017
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Either generate code for a SQL/MP release version that supports the new
features, or remove the new features from the expression.
SQL 7018
Cause. An invalid date-time qualifier was used on a DATETIME or INTERVAL value. A
valid date-time qualifier cannot contain a leading field precision value. A valid date-time
qualifier on an INTERVAL value must belong to either the year-month class or the day-
fraction class.
Effect. The statement does not compile.
Recovery. Correct the date-time qualifier.
7016 The expression contains an element or elements that must
be converted to local civil time before being evaluated.
Such expressions are not allowed in a constraint or
protection view.
7017 The expression contains features that are not supported
by the NonStop SQL/MP release version for which this
expression is being generated.
7018 The date-time qualifier specified is not valid for the
value-1 operand.