Error Code 42000 Teradata
Contents |
turn on suggestions Auto-suggest helps you quickly narrow down your search results
Error Code 6760 In Teradata
by suggesting possible matches as you type. error code 2679 in teradata Showing results for Search instead for Did you mean: Teradata : Product
6706 Error Code In Teradata
Forums : General : Error Code 3785 Options Subscribe to RSS Feed Mark Topic as New Mark Topic as teradata error code 2683 Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page anniemalec Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-28-2011 05:34 AM 03-28-2011 pdo error code 42000 05:34 AM Error Code 3785 HelloI'm currently writing a query including an inner join, however when I run it Teradata is throwing back error code 3785 'expected ANY or ALL is missing.' This error code however is not anything my colleagues or I have experienced before and the help function/google are not being very helpful!My syntax is:"SELECTTRIM (prodvm.customer_letter.Trading_Code||prodvm.customer_letter.Account_Number) AS Customer_Number,prodvm.customer_letter.Letter_Type_Code,prodvm.customer_letter.Parcel_Number,prodvm.customer_letter.Week_Letter_Processed,prodvm.balance_adjustment.adjustment_reason_codeFROMprodvm.customer_letterINNER JOINprodvm.balance_adjustment ON (TRIM (prodvm.customer_letter.Trading_Code||prodvm.customer_letter.Account_Number)) = (TRIM (prodvm.balance_adjustment.Trading_Code||prodvm.balance_adjustment.Account_Number))WHEREprodvm.balance_adjustment.adjustment_reason_code = ('B', 'C')ANDprodvm.customer_letter.week_letter_processed BETWEEN '201027' AND '201149'"If anyone has any idea how to overcome this error, you're help will be greatly appreciated.Thanks,Annie. Everyone's Tags (3): 3785error codesyntax error 0 Kudos Reply All Forum Topics Previous Topic Next Topic 1 REPLY dnoeth Senior Supporter Options Mark as Ne
Posted: Fri, 01 Apr 2005 @ 12:02:58 GMT
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/38610320/teradata-error-42000 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow http://www.forumtopics.com/busobj/viewtopic.php?p=879508 Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Teradata Error 42000 up vote 0 down vote favorite error code I am getting following error while executing sql command through ODBC. Details: "ODBC: ERROR [42000] [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like an 'UDFCALLNAME' keyword between '.' and the 'SUM' keyword. " The code i am running is following. SELECT t1.BALANCE_DATE, t1.SUM(LCY_BALANCE) AS TOTAL_DEP, t2.SUM(LCY_BALANCE) AS TOTAL_CASH FROM (SELECT LCY_BALANCE, BALANCE_DATE FROM MY_BALANCE_TABLE WHERE LINE_NUMBER BETWEEN '2300' AND '3311' AND BALANCE_DATE BETWEEN '2015-07-01' AND 2016-06-30' AND error code 42000 BRANCH_CODE = '5520' GROUP BY BALANCE_DATE) t1 LEFT JOIN (SELECT LCY_BALANCE, BALANCE_DATE FROM MY_BALANCE_TABLE WHERE LINE_NUMBER IN ('0040','0050','0060','0105','0110','0115') AND BALANCE_DATE BETWEEN '2015-07-01' AND 2016-06-30' AND BRANCH_CODE = '5520' GROUP BY BALANCE_DATE) t2 ON t1.BALANCE_DATE = t2.BALANCE_DATE What could be the error, please guide. Regards KAM odbc teradata share|improve this question asked Jul 27 at 10:25 KhawarAmeerMalik 335 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Don't qualify the SUM: SELECT t1.BALANCE_DATE, SUM(t1.LCY_BALANCE) AS TOTAL_DEP, SUM(t2.LCY_BALANCE) AS TOTAL_CASH FROM share|improve this answer answered Jul 27 at 11:04 dnoeth 29.8k2926 Thanks dnoeth. It worked fine. –KhawarAmeerMalik Jul 27 at 11:37 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged odbc teradata or ask your own question. asked 2 months ago viewed 29 times active 2 months ago Related 2SAS connection to Teradata Database using Teradata ODBC2Error after
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. state 42000 error in deski report Search this topic...|Search Desktop Intelligence...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> Desktop Intelligence Author Message passportSenior MemberJoined: 07 May 2010Posts: 85 Posted: Thu Mar 29, 2012 10:34 amPost subject: state 42000 error in deski report Hi Please help me with the following error.When i remove the "Drop statement from the freehand sql the deski report works fine, i want the "drop statement in the sql. I have also verified the ODBC drivers on the server and the local pc, both are same. We are using below query in free hand sql in deski but its giving this error.. Exception: DBD, [NCR][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like ';' between the word 'ysu_hybrid_sub' and the 'create' keyword. State: 42000 drop table user_rpt.ysu_hybrid_sub; create table user_rpt.ysu_hybrid_sub as (select sah.dim_account_id from bi_dmv.SUBSCRIPTION_ATTR_HIST sah where sah.RECORD_END_DATE is null and sah.dim_rate_plan_id not in (select rpr.dim_rate_plan_id from bi_dmv.rate_plan_dimension rpr where rpr.rate_plan_desc like '%mbb%' group by 1) and sah.dim_account_id in (select sah.dim_account_id from bi_dmv.SUBSCRIPTION_ATTR_HIST sah where sah.RECORD_END_DATE is null and sah.dim_rate_plan_id in (select rpr.dim_rate_plan_id from bi_dmv.rate_plan_dimension rpr where rpr.rate_plan_desc like '%mbb%' group by 1) group by 1 ) group by 1) with data primary index(dim_account_id); Back to top digpenForum AddictJoined: 15 Aug 2002Posts: 2854Location: Building the next big thing... Posted: Thu Mar 29, 2012 11:50 amPost subjec