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
|