Failure 3706 Syntax Error
Contents |
All communityThis categoryThis boardKnowledge 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
Teradata 3706 Syntax Error Data Type
Did you mean: Teradata : Product Forums : Analytics : SELECT Failed. create table failed. 3706 syntax error expected something between ')' and ' ' 3706: Syntax error: expected somet... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read teradata 3706 all expressions in a derived table Float this Topic to the Top Bookmark Subscribe Printer Friendly Page bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend
Teradata Error 3706 All Expressions In A Derived Table
Report Inappropriate Content 03-31-2011 12:25 PM 03-31-2011 12:25 PM SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. I am troubling over this error as I am not sure what the cause might be. Any help would be greatly appreciated.select Id, (select case when Fall_score = b.MaxScore then 'Fall' when Spring_score = b.MaxScore then 'Spring' from sandbox.testtable t
Teradata Error 3707
where t.Id = b.Id ) as MaxScoreCategory,MaxScorefrom (select Id, max(Score) as MaxScore from (select Id, 'Fall', Fall_score from sandbox.testtable union all select Id, 'Spring', Spring_score from sandbox.testtable) a (Id, Category, Score) group by Id) bResult:SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. Everyone's tags (2): 3706 errorsyntax 0 Kudos Reply All forum topics Previous Topic Next Topic 20 REPLIES Jim_Chapman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:35 PM 03-31-2011 02:35 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. Which Teradata version are you using? Scalar subqueries in the select list were not supported until 13.0. 0 Kudos Reply bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:45 PM 03-31-2011 02:45 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. The DB version is 12 (SQL asst is 13). can you think o
boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing 3706 error in teradata all expressions results for Search instead for Did you mean: Teradata : Product
Expected Something Between A String Or A Unicode Character Literal
Forums : Database : Failed Query! Not sure why - 3706 Syntax Error? Options Subscribe to 3706: syntax error: expected something between a string or a unicode character literal and ',' RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page timloud Fan Options Mark as http://community.teradata.com/t5/Analytics/SELECT-Failed-3706-Syntax-error-expected-something-between-and/td-p/62131 New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 05-15-2012 05:30 PM 05-15-2012 05:30 PM Failed Query! Not sure why - 3706 Syntax Error? I'm trying to query our database by running the following SQL statement (see below) in Teradata SQL Assistant, but I keep http://community.teradata.com/t5/Database/Failed-Query-Not-sure-why-3706-Syntax-Error/td-p/54351 recieving this error message - "Query Failed. [3706] Syntax Error. Data Type "cust_id" does not match a Defined Type name" I've run this same SQL statement multiple times in the past, not sure why I'm having problems any suggestions for troubleshooting?... SELECT DISTINCT concat(a.cust_id,a.sell_to_loc_id), a.sell_to_loc_name, c.loc_street_txt, c.city_name, c.state_cd, c.ctry_cd, c.zip_cd FROM edward.active_cust_plate a JOIN edward.cust_loc c ON a.cust_srce_cd = c.cust_srce_cd and a.cust_id = c.cust_id and a.sell_to_loc_id = c.cust_loc_id JOIN edward.account_grps g ON a.cust_id = g.cust_id WHERE (g.acct_grouping_lvl_cd = 'C' and a.cust_srce_cd = 'C') AND g.acct_grp_cd IN ('BEALL''S DEPT STORES INC', 'BELK', 'BOB STORES CORP', 'BON-TON DEPT STORES INC', 'BOSCOVS DEPT STORE INC', 'DILLARD''S', 'FRED MEYER STORES INC', 'JC PENNEY CORP INC', 'KOHLS DEPT STORE', 'MACY''S HEADQUARTERS', 'NORDSTROM', 'SEARS ROEBUCKCO', 'STAGE STORES INC') AND CASE c.loc_clsd_dt WHEN '1582-01-01' THEN NULL ELSE c.loc_clsd_dt END > '2010/04/22' AND a.sap_sell_to
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management http://datawarehouse.ittoolbox.com/groups/technical-functional/teradata-l/explain-failed3706syntax-errorexpected-something-between-and-the-group-keyword-4458664 SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Dennis Stevenson bracke Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm syntax error AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Dell Software Panaya Inc. Oracle VAI View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Groups Ask a New Question Teradata For discussion on Teradata , please visit the Data Warehouse – General Discussions group. More Data Warehouse Groups Your account is ready. You're now being signed 3706 syntax error in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. 'explain failed.3706:Syntax Error:expected something between ')' and the GROUP keyword' User_1269 asked Oct 10, 2011 | Replies (1) While executing the EXPLAIN for below query I'm getting the error as "explain failed.3706:Syntax Error:expected something between ')' and the GROUP keyword". INSERT INTO IDM_UNIFY_T.WC_AGENT_PERFORM_TARGETS_D ( STAFFGROUP_NAME, MONTH_WID, MONTH_START_DATE, MONTH_END_DATE, RESOLUTION_MS, RESOLUTION_MTS, RESOLUTION_ES, RESOLUTION_EM, RESOLUTION_WGHT, ASAT_MS, ASAT_MTS, ASAT_ES, ASAT_EM, ASAT_WGHT, AHT_MS, AHT_MTS, AHT_ES, AHT_EM, AHT_WGHT, CPH_MS, CPH_MTS, CPH_ES, CPH_EM, CPH_WGHT, CMM_ADHERENCE_MS, CMM_ADHERENCE_MTS, CMM_ADHERENCE_ES, CMM_ADHERENCE_EM, CMM_ADHERENCE_WGHT, INBOUND_HANDLE_TIME_MS, INBOUND_HANDLE_TIME_MTS, INBOUND_HANDLE_TIME_ES, INBOUND_HANDLE_TIME_EM, INBOUND_HANDLE_TIME_WGHT, SMIR_MS, SMIR_MTS, SMIR_ES, SMIR_EM, SMIR_WGHT, LOGIN_COMPLIANCE_MS, LOGIN_COMPLIANCE_MTS, LOGIN_COMPLIANCE_ES, LOGIN_COMPLIANCE_EM, LOGIN_COMPLIANCE_WGHT, ETL_PROC_WID, W_INSERT_DT, W_UPDATE_DT) SELECT STAFFGROUP_NA