ADSM-L

Select Question

2000-02-18 15:34:47
Subject: Select Question
From: "Dana Mitchell;" <Dana.Mitchell AT ING-DM DOT COM>
Date: Fri, 18 Feb 2000 14:34:47 -0600
Hello all,

I am trying to create a Select query that will list items from the TSM
'summary' table and total number of GB by activity by day.  When I try:

SELECT  DATE(START_TIME),  ACTIVITY, SUM(AFFECTED),
SUM(CAST(BYTES/1024/1024/1024 AS DECIMAL(8,2))) +
 FROM SUMMARY WHERE COMMMETH IS NULL GROUP BY DATE(START_TIME), ACTIVITY

I receive:

ANR2904E Unexpected SQL key word token - 'DATE'.
                                              |
         .....................................V.........................
         MARY WHERE COMMMETH IS NULL GROUP BY DATE(START_TIME), ACTIVITY
ANS8001I Return code 3.
ANS8002I Highest return code was 3.


I can't get the GROUP BY clause to work based on the date.  Does anyone
have any suggestions?

Thanks in advance
Dana

PS:  Please reply to my address also, I get the digest version and
sometimes it doesn't all make it to me intact.  Thanks
<Prev in Thread] Current Thread [Next in Thread>
  • Select Question, Dana Mitchell; <=