SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-11
SQL 4037
Cause. You attempted to extract field name from a source whose type
specification does not support this.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4038
Cause. You attempted to perform an AVG or SUM function with an invalid operand. It
must be numeric or interval.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4039
Cause. You specified column name with type specification1, which is
incompatible with the type of the value.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 4040
Cause. You specified operands for a BETWEEN predicate that are not of equal
degree, which is required.
Effect. The operation fails.
Recovery. Correct the syntax so that the operands are of equal degree and resubmit.
4037 Field name cannot be extracted from a source of type
specification.
4038 The operand of an AVG or SUM function must be numeric or
interval.
4039 Column name is of type specification1, incompatible with
the value's type, specification2.
4040 The operands of a BETWEEN predicate must be of equal
degree.