Teradata Database Message 6807 - 6807 - Analytics Database - Teradata Vantage

Message

Invalid relational operation involving %VSTR. Cast them to the same UDT data type.

Explanation

This error occurs when a term of the form, "leftExpr RelationalOp rightExpr", evaluates such that the leftExpr and rightExpr are not of compatible Udt data types. For two Udts to be compatible, they must be exactly equal, or there must exist a cast function which enables one Udt to be casted to the other Udts data type. Also, for early release, the casting must be explicitly typed in on the SQL input.

Generated By

OPT module. .

For Whom

End User.

Notes

User SQL statement formulation error

Remedy

Use exactly equal Udt data types for all relational operations, or supply explicit casts to insure that the relational operation is upon equal Udt data types.