Ok, this is getting weird. Right out of the example: SELECT SUBSTR(WORKDEPT,1,1), MIN(EDLEVEL), MAX(EDLEVEL) FROM DSN8910.EMP GROUP BY SUBSTR(WORKDEPT,1,1) ; ---------+---------+---------+---------+---------+---------+---------+---------+ DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: FOR WITH FETCH ORDER UNION EXCEPT QUERYNO OPTIMIZE DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 0 0 0 -1 2040 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'000007F8' X'00000000' SQL DIAGNOSTIC INFORMATION
Must be something I'm doing wrong. Has to be, but I don't yet see it. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of McKown, John Sent: 17. kesäkuuta 2008 0:14 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: DB2 group by with date functions Select Year(Expdate), Month(Expdate) , Category, Sum(Expamt) from EXP.EXPENSES group by Year(expdate), Month(Expdate), category order by 1 desc, 2 desc, 3 ref: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPK10/1.1. 6 -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html