Re: Select Command
1999-02-18 14:54:07
Subject: |
Re: Select Command |
From: |
Donald Daniels <Donald_W._Daniels/FFIC AT FFIC DOT COM> |
Date: |
Thu, 18 Feb 1999 11:54:07 -0800 |
Robert, try ..
select sum(logical_mb) as "Capacity", stgpool_name from occupancy group by
stgpool_name
regards,
Don Daniels
Robert Ouzen <robert AT RESEARCH.HAIFA.AC DOT IL> on 02/18/99 02:46:39 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Select Command
Hello
Try to run a select command to get the occupancy for each storage pool,
but get an error. The syntax I ran:
select logical_mb as "Capacity" from occupancy group by stgpool_name
What is the correct syntax !!!!!
Regards Robert
*****************************************************************
* Ouzen Robert E-mail: robert AT research.haifa.ac DOT il *
* Helpdesk Manager Phone: (972)-4-8240345 *
* Computer Center Fax: (972)-4-8342097 *
* University of Haifa (972)-4-8249177 *
* Mt. Carmel, Haifa 31905 Israel *
*****************************************************************
|
|
|