Rdbms Error 3706 Syntax Error Expected Something Between The Word
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 failure 3706 syntax error in teradata Search instead for Did you mean: Teradata : Product Forums :
Syntax Error Expected Something Between ')' And ' '
Analytics : 3706: Syntax error: expected something between ')... Options Subscribe to RSS Feed Mark Topic as New create table failed. 3706 syntax error expected something between ')' and ' ' Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page dsad Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get
Teradata 3706 Syntax Error Data Type
Direct Link Print Email to a Friend Report Inappropriate Content 05-09-2006 08:05 PM 05-09-2006 08:05 PM 3706: Syntax error: expected something between ')' and ','. For derived Hi TD newbie here,am getting the 3706: Syntax error: expected something between ')' and ','.for the following querySELECT P.SRCSYS_CODE,P.SUP_NM,L.SRC_LOC_CD,L.LOC_NAME,D.DEST,COUNT(ITM_NUM),COUNT(ORD_NUM),COUNT(ORD_LN)FROM (SELECT ORD_NUM, ORD_LN, ORD_LN_ST,ITM_NUM, ORD_QTY,LOC_NAME AS DESTFROM ORD_DET A, LOC BWHERE expected something between a string or a unicode character literal A.LOC_ID = B.LOC_IDAND A.ORD_LN_ST = 'CLOSED') D,ORD O, PAR P, LOC LWHERE D.ORD_NUM = O.ORD_NUMAND O.PAR_ID = P.PAR_IDAND O.LOC_ID = L.LOC_IDGROUP BY 1,2,3,4,5 ;am not sure where the problem is?any help appreciated. 0 Kudos Reply All forum topics Previous Topic Next Topic 16 REPLIES pwsegal1 Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 05-10-2006 07:25 AM 05-10-2006 07:25 AM Re: 3706: Syntax error: expected something between ')' and ','. For derived Try this (assuming the counts that are from the drived table).SELECT P.SRCSYS_CODE,P.SUP_NM,L.SRC_LOC_CD,L.LOC_NAME,D.DEST,COUNT(D.ITM_NUM),COUNT(D.ORD_NUM),COUNT(D.ORD_LN)FROM (SELECT ORD_NUM,ORD_LN,ORD_LN_ST,ITM_NUM,ORD_QTY,LOC_NAME AS DESTFROM ORD_DET A, LOC BWHERE A.LOC_ID = B.LOC_IDAND A.ORD_LN_ST = 'CLOSED')AS D,ORD O, PAR P, LOC LWHERE D.ORD_NUM = O.ORD_NUMAND O.PAR_ID = P.PAR_IDAND O.LOC_ID = L.LOC_IDGROUP BY 1,2,3,4,5 ; 0 Kudos Reply dsad Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 05-10-2006 01:50 PM 05-10-2006 01:50 PM Re: 3706: Syntax error: expected something between ')' a
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 Did you mean: Teradata : Product Forums : Database : Error: Syntax
Teradata 3706 All Expressions In A Derived Table
error: expected something between th... Options Subscribe to RSS Feed Mark Topic as New Mark
Teradata Error 3706 All Expressions In A Derived Table
Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page Lillian_Ding Fan Options Mark as New Bookmark 3706: syntax error: expected something between a string or a unicode character literal and ',' Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-24-2014 08:14 PM 09-24-2014 08:14 PM Error: Syntax error: expected something between the word 'a' and '.' Hi all,I'm new https://community.teradata.com/t5/Analytics/3706-Syntax-error-expected-something-between-and-For-derived/td-p/1286 to Teradata and just started using it a week ago. I have trouble figuring out what is wrong with the following short code:create table c as( select a.col_1, a.col_2, sum(a.col_3) as total_col_3, count(a.col_4) as cnt_col_4from TABLE_A a, TABLE_B bwhere a.col_5=b.col_5 and a.col_6=b.col_6group by 1,2) with data primary index(a.col_5);Any advice or suggestion would be highly appreciated. Thanks! 0 Kudos Reply All forum topics Previous Topic Next Topic 6 REPLIES Raja_KT Enthusiast Options Mark as http://community.teradata.com/t5/Database/Error-Syntax-error-expected-something-between-the-word-a-and/td-p/18238 New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-24-2014 10:25 PM 09-24-2014 10:25 PM Re: Error: Syntax error: expected something between the word 'a' and '.' You do not have a.col5.Give an alias to all columns. It is a good way to identify.Try this, putting a.col1 as PI. You can change later.create table c as ( select a.col_1 as jj, a.col_2 as kk, sum(a.col_3) as total_col_3, count(a.col_4) as cnt_col_4 from TABLE_A a, TABLE_B b where a.col_5=b.col_5 and a.col_6=b.col_6 group by 1,2) with data primary index(jj); 0 Kudos Reply Lillian_Ding Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-25-2014 08:44 PM 09-25-2014 08:44 PM Re: Error: Syntax error: expected something between the word 'a' and '.' Hi Raja_KT, thank you for your help. It solved the problem. 0 Kudos Reply kingkong Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 02-04-2015 12:06 PM 02-04-2015 12:06 PM Re: Error: Syntax error: expected something between the word 'a' and '.' select a12.xx xx,a12.bb bbfrom (select a11.zz zz,CASE WHEN substring(a11.zz ,2,1) between '0' and '9' THEN substring(a11.zz,1,1) ELSE substring(a11.zz,1,2) END zzfrom table1
Marketplace View all Dashboard Gallery Visualization Library General Discussions View all Getting Started with the https://community.microstrategy.com/t5/Reporting-Dashboards-and/Syntax-error-expected-something-between-and/td-p/235074 Community Community News Get Connected Business Strategy & Best Practices Suggestions for this Community Technical Discussions View all Announcements Tech Corner Idea Exchange Platform (Installation http://datawarehouse.ittoolbox.com/groups/technical-functional/teradata-l/failure-3706-syntax-error-expected-something-between-the-date-keyword-and-4618099 & Deployment) Object Development Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets (Data Sources syntax error & 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 Groups View all MicroStrategy Masters '15-'16 Customer Advisory Council Customer Speakers Community Menu Register · expected something between Sign In · Help Reporting, Dashboards, and Document Development MicroStrategy > Technical Discussions > Reporting, Dashboards, and Document Development > Syntax error: expected something between ')' and ','. CommunityCategoryBoardKnowledge BaseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Syntax error: expected something between ')' and ','. Reply Topic Options Float Topic for All Users Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » aaware6 Pioneer Posts: 34 Registered: 03-23-2015 Syntax error: expected something between ')' and ','. Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Content 03-23-2015 05:28 PM Error: SQL Gen
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management 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 Inside-CRM Inside-ERP I_am_the_dragon VoIP_News MacProTX maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke AbhaiTripathi Adrian_Grigoriu Nikki Klein Iqbalyk blrvenkat numbersguyPA COMPANIES Quest Software Imation Wave Direct Skybot Software 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 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. Failure 3706 Syntax Error: Expected Something Between the 'DATE' Keyword and ':' venkatesh.chitravelu asked Jan 27, 2012 | Replies (4) Hi, I face a problem with following error. Please help me to solve it. Thanks. WHERE prod_app_dt BETWEEN (DATE :START_WK-550) AND :END_WK $ *** Failure 3706 Syntax error: expected something between the 'DATE' keyword and ':'. The above code works with hard coded value, but it does not work with parameters. WHERE prod_app_dt BETWEEN (DATE '2011-02-01'-550) AND '2011-02-28' --> this works. When replacing the hard coded value with parameter, it throws an error saying " *** Failu