Your are right, it is better to use quotes.
But the problem with the group by isn't solved.
Regards
Stefan Holzwarth

-----Ursprüngliche Nachricht-----
Von: Paul Miller [mailto:Paul_Miller AT CARGILL DOT COM]
Gesendet: Donnerstag, 24. Oktober 2002 15:44
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: Group by problem for Storagereports


Shouldn't you group by "SERVERTYP"?  I think you need the quotes.
 
Paul Miller
 
-----Original Message-----
From: stefan.holzwarth AT ADAC DOT DE [mailto:stefan.holzwarth AT ADAC DOT DE]
Sent: Thursday, October 24, 2002 7:19 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Group by problem for Storagereports
 
 
Hello,
 
i tried to realize some storage reports about out NT servers with the
following select:
 
select substr(nodes.contact,1,1) as SERVERTYP ,sum 
(filespaces.capacity), -
      sum (filespaces.capacity*pct_util/100) from nodes,filespaces 
where filespace_name like '%\c$' and 
nodes.node_name=filespaces.node_name 
group by SERVERTYP
 
But:
===
ANR2940E The reference 'SERVERTYP' is an unknown SQL column name.
                                                            |
         ......................................................V........ 
         c$' and nodes.node_name=filespaces.node_name group by SERVERTYP
 
 
Any ideas who to group by the first letter of the description?
 
(I use the first letter for asigning the Server to some goups like mail, 
application, file,.....)
 
Kind regards,
 
Stefan Holzwarth
 
------------------------------------------------------------------------
----
--
Stefan Holzwarth
ADAC e.V. (Informationsverarbeitung - Systemtechnik - Basisdienste)
Am Westpark 8, 81373 München, Tel.: (089) 7676-5212, Fax: (089) 76768924
mailto:stefan.holzwarth AT adac DOT de