The group by statement is incorrect, use the following:

group by pending_date

the conversion to date format is already taken care of
in the first part of the select statement.

David E Ehresman wrote:

tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes
where -
cont> status='PENDING' group by "Date"
ANR2940E The reference 'Date' is an unknown SQL column name.

                                                                  |

.........................................................V.....
         e",count(*) from volumes where status='PENDING' group by
"Date"

ANS8001I Return code 3.

mark.stapleton AT BERBEE DOT COM 11/30/2004 9:09:03 AM >>>

From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf Of David E Ehresman

I'm trying to get a count of tapes pending by date.  I'm using:
      select date(pending_date),count(*) from volumes where
status='PENDING' -
 group by date(pending_date)
but I get the error message:
 ANR2904E Unexpected SQL key word token - 'DATE'.
pointing to the date in the group by clause.

Anyone know how to get a pending count by date?

Try

  select date(pending_date) as "Date",count(*) from volumes where
status='PENDING' group by "Date"

--
Mark Stapleton (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627