SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-11
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.
SQL 4041
Cause. You attempted to compare two type specifications that cannot be compared.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
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.
4041 Type specification1 cannot be compared with type
specification2.