15.10 - 3654 Corresponding select-list expressions are incompatible. - Teradata Database

Teradata Database Messages

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

3654 Corresponding select-list expressions are incompatible.

Explanation:

If a query contains a UNION, MINUS, or INTERSECT operator, then the data types for all select-list expressions must be compatible with the corresponding expression in the select-list for the first SELECT in the query. All numeric data types are considered compatible. Character data types are not compatible with numeric data types. Byte data types are only compatible with byte data types. Graphic data types are only compatible with graphic data types.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

Correct the statement and resubmit the request.