15.00 - 3600 Comparisons are not allowed for the type %VSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

3600 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.

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.