Error 3654

Error In Teradata p Posted Thu relatedl May GMT Prev Next First Prev Next Last Subj Re UNION Corresponding select-list expressions are incompatible From Anomy Anom -- Anonymously Posted Thursday May -- Names don't matter Data types do First change the to the lists of column names If there is still an issue look at corresponding DDL or use TYPE columnname attribute function to query You will find a mismatch - something in the first list which doesn't match the corresponding entry in the second list AND there is no implicit conversion available from the type in the second list

error 3654 corresponding select-list expressions are incompatible

Error Corresponding Select-list Expressions Are Incompatible p baseUsers input input turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type Showing results for Search instead for Did you relatedl mean Teradata Product Forums Database Problem while using UNION Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page SAP Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content - - PM - - PM

error 3654

Error p expressions are incompatible Teradata relatedl code Corresponding select-list expressions are incompatible Error description error explanation 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

- 1