Teradata Database Message 3600 - 3600 - Analytics Database - Teradata Vantage

Message

Comparisons are not allowed for the type %VSTR.

Explanation

This type is not allowed to be compared with equals, less than, greater than, etc. Users cannot modify the type in any way that will allow it to be comparable because the functionality has been denied internally. Array types are an example of a kind of type that cannot be compared.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Remove the comparison and resubmit. If a comparison is needed, there may be functions that allow comparisons between the desired types. For example, Array types use the following functions for comparisons: ARRAY_GT, ARRAY_GE, ARRAY_LE, ARRAY_EQ, ARRAY_NE.