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                                *
*****************************************************************