Teradata Database Message 3600 - 17.10 - 3600 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.