Hi:
This provides a count by storage group:

dsmadmc -id=xxxxx -pa=xxxxx 'select stgpool_name,count(*) from volumes group by 
 stgpool_name'

Larry Clark
NYS Thruway Authority


>>> "Doherty, John (ANFIS)" <jdohe1 AT ANFIS.CO DOT UK> 02/17/00 07:42AM >>>
Can anyone tell me how to incorporate a count parameter into SQL statements

For example i can execute the following SQL statements:

select node_name,volume_name,stgpool_name from volumeusage where
node_name='$1'

But I would like a count at the end to tell me the number of volumes in
question

Thanks in advance

> John Doherty. Tel:   +44   (0)   141 275 7793
>               Fax:  +44   (0)   141 275 9199
>               Email: JDohe1 AT Anfis.co DOT uk 
>
>       Technical Specialist, Storage Management L02S
>
> Email communications are not necessarily secure and may be intercepted or
> changed after they are sent.  Abbey National Financial and Investment
> Services  does not accept liability for any such changes. If you wish to
> confirm the origin or content of this communication, please contact the
> sender using an alternative means of communication.  This communication
> does not create or modify any contract.  If you are not the intended
> recipient of this communication you should destroy it without copying,
> disclosing or otherwise using its contents.  Please notify the sender
> immediately of the error.
>
> ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
>         Registered Office Abbey National House 287 St Vincent Street
>         Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
>