AIX 5.2, DB2 V8, FIXPAk 5 (bunch of special builds)


I have a the following table:
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- -----
NAME SYSIBM INTEGER 4 0 No
CLOSETS SYSIBM VARCHAR 14 0 No
LASTMOVE SYSIBM VARCHAR 14 0 No
BACKUPTS SYSIBM VARCHAR 14 0 Yes
OBJID SYSIBM INTEGER 4 0 No
SIZE SYSIBM INTEGER 4 0 No
MIRROR_FLAG SYSIBM CHARACTER 1 0 Yes


I am running the following SQL to get totals for each day

select count(*) from sapr3.db6logfile where lastmove like '20040817%'

Now my issue, I have tried to change it so I can run this and supply a year and month like '200408%' and group and order it by the date so I can get a months worth of data instead of individual days. My ouput would contain 2 columns, First column is the date, 2nd is the #of records for that date.

I appreciate any help anybody can give me. I havn't done that much SQL in 5 years now and I'm getting very rusty.

If I understand your question correctly the following should work: