Error Sqlcode=-119 Sqlstate=42803
Contents |
sure to check out the FAQ by clicking the link above. You may have to register before you db2 group by can post: click the register link above to proceed. To start db2 sql error: sqlcode=-104, sqlstate=42601 viewing messages, select the forum that you want to visit from the selection below. Results 1 to
Db2 Error Code
4 of 4 Thread: DB2 sqlcode: -119 sqlstate: 42803 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/n119.html Switch to Hybrid Mode Switch to Threaded Mode 05-07-13,03:42 #1 @swathi View Profile View Forum Posts Registered User Join Date May 2013 Posts 3 Unanswered: DB2 sqlcode: -119 sqlstate: 42803 sqlcode: -119 sqlstate: 42803 Last edited by @swathi; 05-10-13 at 07:31. Reply With Quote 05-07-13,03:48 #2 przytula_guy View Profile View Forum Posts Visit Homepage Registered User http://www.dbforums.com/showthread.php?1692628-DB2-sqlcode-119-sqlstate-42803 Join Date Apr 2006 Location Belgium Posts 2,514 Provided Answers: 11 so, what is the problem ? sum needs group by Best Regards, Guy Przytula Database Software Consultant Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs. Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence. DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop.. Information Server Datastage Certified http://www.infocura.be Reply With Quote 05-07-13,09:16 #3 tonkuma View Profile View Forum Posts Registered User Join Date Feb 2008 Location Japan Posts 3,483 The difficulty(or troublesome) might be which columns of which tables should be included in GROUP BY clause. I formatted your query by my way, to understand construction/structure of the query. Code: SELECT SUM(AVL.MEETING_MIN) , SRS.* , RS.NAME FROM SCRUM_MASTER.RES_AVAIL_HRS AVL , SCRUM_MASTER.SCRUM_PROJECT_RESOURCE SRS , SCRUM_MASTER.RESOURCE RS , SCRUM_MASTER.SCRUM_SPRINT SPT WHERE A
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 http://database.ittoolbox.com/groups/technical-functional/sql-l/group-by-when-trying-to-group-on-a-single-column-5070876 Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database https://jazz.net/forum/questions/180832/anyone-having-issues-with-own-sql-code-with-jazz-reporting-service Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Compuware Wave Direct Cisco EdgeWave View All Topics View All Members View db2 sql All Companies Toolbox for IT Topics Database Groups Ask a New Question SQL The SQL group is a forum where peers share technical expertise, solve problems, and discuss issues related to SQL (Structured Query Language). Home | Invite Peers | More Database 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 db2 sql error: 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. Group by when trying to Group on a Single Column KAL-EL_KANATA asked Jan 18, 2013 | Replies (7) I have a Table that has a column with Part numbers each part number has a % associated to it by 4 or 5 other columns For example a single part could have the sale of that part broken up by licensing, support, install, and HW by percent So a single part has 4 separate row entries for each % it is broken into. now I want to merge all the 4 rows of each unique part into 1 single row. I though I could use group by but I get this error Select * from Ledger_BOM_Prod as A Group by A.PART_NUM An expression starting with "REV_SPLIT" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified
×147 sql_jrs ×10 Asked: May 11 '15, 9:28 a.m. Seen: 1,108 times Last updated: May 11 '15, 11:54 a.m. Related questions Aggregate function on date difference not working in JRS Can we calculate effort spent/in hrs on each state against a custom workitem in JRS? Planned leaves and over time in JRS Estimate and Time spent attributes in JRS How do I use/deploy same JRS query which is been edited using Advanced section (SQL) for other project areas? Calculating aging of workitem states in JRS Test Productivity calculation in JRS Employee Productivity calculation in JRS Jazz Reporting Service "Connect to Data Sources" error JRS Data Source Configuration with mySQL FAQ - How this Forum works Anyone having issues with own SQL code with Jazz Reporting Service ? 1 Iciar Matilde Olocco y Garcia (73●8●17) | asked May 11 '15, 9:28 a.m. HI ! I try to create my own SQL queries but in some case, I've received error with try to join two tables and use COUNT function This is my code: SELECT P.PROJECT_CLASS_ID, C.NAME, COUNT(P.PROJECT_CLASS_ID) As QProject FROM RIODS.PROJECT P INNER JOIN RIODS.PROJECT_CLASSIFICATION C ON P.PROJECT_CLASS_ID=C.PROJECT_CLASS_ID GROUP BY P.PROJECT_CLASS_ID This is the error: CRRGW5628E An com.ibm.db2.jcc.am.SqlSyntaxErrorException error occurred when validating the input SQL string, caused by DB2 SQL Error: SQLCODE=-119, SQLSTATE=42803, SQLERRMC=NAME, DRIVER=4.14.121. 10:26:28 AM An unexpected error occurred when validating the input SQL string. Check the reporting service log file for details. But if you check both table you can find the information. Could you help me? Accepted answer 1 link Vinaykumar Saraogi (34) | answered May 11 '15, 9:47 a.m. JAZZ DEVELOPER Hi, Looks like you forgot to include C.NAME in the GROUP BY clause. The query should be something like this: SELECT P.PROJECT_CLASS_ID, C.NAME, COUNT(P.PROJECT_CLASS_ID) As QProject FROM RIODS.PROJECT P INNER JOIN RIODS.PROJECT_CLASSIFICATION C ON P.PROJECT_CLASS_ID=C.PROJECT_CLASS_ID GROUP BY P.PROJECT_CLASS_ID, C.NAME Iciar Matilde Olocco y Garcia selected this answer as the correct answer 3 other answers Most liked answers ↑|Newest answers|Oldest answers 1 link Lidija Grahek (46●1) | answered May 11 '15, 9:39 a.m. JAZZ DEVELOPER Hi, You are missing C.NAME in GROUP BY statement. 0 link Jackie Albert (1.3k●1●36●