Neoview Messages Manual (Volume 1) (R2.4)
SQL 4035
4035 Type specification1 cannot be cast to type specification2.
Cause You attempted to cast type specification1 to another type specification2
that is not valid.
Effect The operation fails.
Recovery Correct the syntax and resubmit.
SQL 4036
4036 The source field of the EXTRACT function must be of DateTime or
Interval type.
Cause You specified a source field of the EXTRACT function that is not a DATETIME or
INTERVAL data type.
Effect The operation fails.
Recovery Correct the source field type and resubmit.
SQL 4037
4037 Field name cannot be extracted from a source of type specification.
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
4038 The operand of an AVG or SUM function must be numeric or interval.
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
4039 Column name is of type specification1, incompatible with the value's
type, specification2.
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
4040 The operands of a BETWEEN predicate must be of equal degree.
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
4041 Type specification1 cannot be compared with type specification2.
Cause You attempted to compare two type specifications that cannot be compared.
133