Try using capital letters.
[EMAIL PROTECTED]
David E Ehresman <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
12/01/2004 08:54 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: SQL Help
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.
>>> [EMAIL PROTECTED] 11/30/2004 9:09:03 AM >>>
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] 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 ([EMAIL PROTECTED])
Berbee Information Networks
Office 262.521.5627
