Andy,
Thanks for the feedback. I may not have been clear in stating my original
question, and now that I've gone back and re-read your ADSM SQL reference,
I think what I'm looking for may not be possible within the syntax of the
SQL Query.
Just to clarify:
>But not my question becomes, why do you have
>"from volumes as pending" instead of just "from volumes"?
This was a typo on my part...
>I would just write:
>select count(*), cast(pending_date as date) as "Reclaimed" -
>from volumes where status='PENDING' group by pending_date
When running this query, the output looks like this:
Unnamed[1] Reclaimed
----------- ----------
1 2001-09-17
(more rows here)
1 2001-09-17
(more rows here)
1 2001-09-24
(more rows here)
2 2001-09-24
(more rows here)
1 2001-09-24
There are multiple results with the same value in "Reclaimed"; the
PENDING_DATE is different because they became pending at different times
during the same calendar day.
What I'm trying to produce would be more like the following:
Unnamed[1] Reclaimed
----------- ----------
7 2001-09-17
10 2001-09-23
11 2001-09-24
The syntax diagram from "Using the ADSM SQL Interface" seems to exclude
anything but a column name that is part of a table from being used for
grouping.
'-GROUP BY--+------------+--.--column_name--'
'-table_name-'
Thanks,
Ted
