Home > error 3654 > error 3654 corresponding select-list expressions are incompatible

Error 3654 Corresponding Select-list Expressions Are Incompatible

baseUsers 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 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 ‎09-28-2014 09:58 PM ‎09-28-2014 09:58 PM Problem while using UNION Hi ,I am unable to run such queries . It says "Executed as Single statement. Failed [3654 : HY000] Corresponding select-list expressions are incompatible. Elapsed time = 00:00:00.000 STATEMENT 1: Select Statement failed."SELECT A.FIELD1,A.FIELD2,a.FIELD3FROM VT_SIBHI1UNIONSELECT NULL AS FIELD1,NULL AS FIELD2CASE WHEN B.FIELD3 = 1 THEN NULL ELSE FIELD3 AS FIELD3FROM VT_SIBHI2 B;Please help me on this Everyone's Tags (1): Corresponding select-li… 0 Kudos Reply All Forum Topics Previous Topic Next Topic 2 REPLIES SAP Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎09-28-2014 10:03 PM ‎09-28-2014 10:03 PM Re: Problem while using UNION Got the answer guys !!! Its like we need to make the datatype match not the Name of the columns . 0 Kudos Reply Gulzar_akhtar N/A Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content ‎12-02-2015 11:18 PM ‎12-02-2015 11:18 PM Re: Problem while using UNION Hi, did u use CAST function to resolve the issue...please let me know...cast('' as char(10))Thanks 0 Kudos Reply Teradata Links Teradata.com Teradata Partners Support & Forums Support Portal / TaYS Teradata Aster Community Communities Downloads Documentation Developer Downloads Teradata Express Teradata Aster Express Teradata Aster Development Environment Community Feedback Teradata.com | Help | | | | | | | RSS Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website,

New Teradata Studio Administration User Experience fgrimmer Tools Teradata & SQLAlchemy: Introduction Mark Sandan Tools Studio 15.12 Available for Download fgrimmer Tools Benchmarking and TdBench 7.2 DougEbel Tools Orchestrating an analytic workflow in the Teradata Unified Data Architecture watzke UDA Routing Options in Unity Director 15.00 Paul LaPointe UDA Introduction to Viewpoint 15.11 Mobile craigmitchell Viewpoint An Overview of the new Viewpoint 15.11 Dashboard craigmitchell Viewpoint Teradata Data Lab 15.11 Release gryback http://community.teradata.com/t5/Database/Problem-while-using-UNION/td-p/18804 Viewpoint Phased Rollouts in Unity Director & Loader Paul LaPointe UDA Why We Love Presto DanGraham Hadoop Transitioning from SQL Assistant to Studio Express fgrimmer Tools Teradata Query Grid and Machine Learning in Hadoop watzke Extensibility Tags 0 - 1 of 1 tags for Corresponding select-list expressions are https://developer.teradata.com/tag/corresponding-select-list-expressions-are-incompatible incompatible Problem while using UNION Hi , I am unable to run such queries . It says "Executed as Single statement.  Failed [3654 : HY000] Corresponding select-list expressions are incompatible. Elapsed time = 00:00:00.000   STATEMENT 1: Select Statement failed."   SELECT A.FIELD1, A.FIELD2, a.FIELD3 FROM VT_SIBHI1 UNION By SAP, 28 Sep 2014 | Tagged: Corresponding select-list expressions are incompatible | 2 comments Contact Us | Privacy Policy | Terms of Use | Send Feedback | Teradata.com Copyright © 2004-2015 Teradata Corporation. Your use of this Teradata website is governed by the Privacy Policy and the Terms of Use, including your rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website. The Privacy Policy and Terms of Use for this Teradata website changed effective April 13, 2015.

General Discussions View all Getting Started with the Community Community News Get https://community.microstrategy.com/t5/Architect/TN32014-quot-Teradata-Database-Corresponding-select-list/ta-p/182903 Connected Business Strategy & Best Practices Suggestions for this http://teradata197.rssing.com/chan-4412770/all_p418.html Community Technical Discussions View all Announcements Visualization Gallery Tech Corner Idea Exchange Platform (Installation & Deployment) Object Development Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets error 3654 (Data Sources & Gateways) MicroStrategy Software Development Kit (SDK) Security (Usher) Performance Events View all Events Blog Symposia 2016 Symposia 2015 Education World 2016 Discussions World 2015 Discussions World 2015 Track Sessions & Customer Presentations Community Menu Register · Sign In · Help Architect MicroStrategy error 3654 corresponding > Architect > TN32014: "[Teradata Database] Corresponding select-list expressions are incompatible" error message appears when clickin... CommunityCategoryKnowledge BaseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. TN32014: "[Teradata Database] Corresponding select-list expressions are incompatible" error message appears when clicking "Attributes" in "My Shortcuts" section in MicroStrategy 9.0 Report Editor against Teradata v12.0. Started ‎01-19-2010 by fish Modified ‎01-19-2010 by fish Article Options Article History Subscribe to RSS Feed Mark as New Mark as Read Bookmark Subscribe Email to a Friend Printer Friendly Page Report Content Labels: Architect , Developer 0 Likes SYMPTOM: When users click "Attributes" under "My Shortcuts" section in MicroStrategy 9.0 Report Editor, the following error occurs: Samp

in your HTML Search confirm cancel Report adult content: click to rate: Account: (login) More Channels Showcase RSS Channel Showcase 3581427 RSS Channel Showcase 4666732 RSS Channel Showcase 8499481 RSS Channel Showcase 8681073 Channel Catalog Subsection Catalog Articles on this Page (showing articles 8341 to 8360 of 14773) 09/26/14--22:25: _output of Stored Pr... 09/27/14--02:32: _output of Stored Pr... 09/27/14--02:36: _Remove characters a... 09/27/14--03:06: _Tuning LIKE Operato... 09/27/14--03:15: _self join of table ... 09/27/14--04:09: _output of Stored Pr... 09/27/14--05:05: _output of Stored Pr... 09/27/14--05:08: _Merge with error ta... 09/27/14--07:10: _Merge with error ta... 09/27/14--09:22: _output of Stored Pr... 09/27/14--09:33: _Send mail from a st... 09/27/14--10:08: _Send mail from a st... 09/27/14--10:08: _output of Stored Pr... 09/27/14--10:09: _Send mail from a st... 09/27/14--11:07: _self join of table ... 09/27/14--20:25: _output of Stored Pr... 09/28/14--11:05: _difference in stat ... 09/28/14--11:20: _difference in stat ... 09/28/14--21:58: _Problem while using... 09/28/14--22:03: _Problem while using... (showing articles 8341 to 8360 of 14773) Browse the Latest Snapshot Browsing All Articles (14773 Articles) Live Browser Channel Description: Database Forum topics and responses older | 1 | .... | 415 | 416 | 417 | (Page 418) | 419 | 420 | 421 | .... | 739 | newer 0 0 09/26/14--22:25: output of Stored Procedure - forum topic by SAP Contact us about this article REPLACE PROCEDURE EDW_DB.TEST_SP1() BEGIN DECLARE SQL1 VARCHAR(100); SET SQL1 = 'SELECT * FROM DBC.TABLES;'; CALL DBC.SYSEXECSQL(SQL1); END ; Comiliation is successfull . but i am unable to get an output while calling the procedure. My requirement is to select the records while running the procedure . Tags:  output of Stored Procedure Forums:  Database 0 0 09/27/14--02:32: output of Stored Procedure - response (1) by dnoeth Contact us about this article Providing an error message instead of "unable to get an output" would be helpful. SysExecSQL/EXECUTE don't support SELECTs. You shoud read the Stored procedures manual, there's a chapter on how to use cursors in Dynamic SQL. REPLACE PROCEDURE TEST_SP1() DYNAMIC RESULT SETS 1 BEGIN DECLARE SQL1 VARCHAR(100); DECLARE crsr CURSOR WITH RETURN ONLY FOR stmt; SET SQL1 = 'SELECT * FROM DBC.TABLES;'; PREPARE stmt FROM SQL1; OPEN crsr; END ;   0 0 09/27/14--02:36: Remove characters after '-' in a string - response (6) by dnoeth Contact us about this article Teradata Timestamps only support 6 digits, so you must strip of the last digit. Do you really have data with that 

 

Related content

error 3654 in teradata

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

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