Yes, you and Alex came up with just what I needed.
Is there somewhere the selects from the query commands are in the data
base? ... Just learning SQL ... JC

> -----Original Message-----
> From: Sung Y Lee [SMTP:sunglee AT US.IBM DOT COM]
> Sent: Wednesday, May 01, 2002 5:25 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: SQL to do q auditoccupancy?
>
> Is this what you are looking for?
>
> q auditoccup =  select node_name,backup_mb,archive_mb, spacemg_mb,total_mb
> from auditocc
> q occup=  select
> node_name,type,filespace_name,stgpool_name,num_files,physical_mb,logical_m
> b
> from occupancy
>
>
> Sung Y. Lee
> E-mail sunglee AT us.ibm DOT com
>
>
>
>                       Alex Paschal
>                       <AlexPaschal@FREIGH        To:
> ADSM-L AT VM.MARIST DOT EDU
>                       TLINER.COM>                cc:
>                       Sent by: "ADSM:            Subject:  Re: SQL to do q
> auditoccupancy?
>                       Dist Stor Manager"
>                       <[email protected]
>                       DU>
>
>
>                       05/01/2002 05:14 PM
>                       Please respond to
>                       "ADSM: Dist Stor
>                       Manager"
>
>
>
>
>
> Auditocc = select node_name, sum(physical_mb) from occupancy group by
> node_name
>
> occupancy = select * from occupancy where ......
>           = select node_ame, filespace_name, sum(physical_mb) from
> occupancy
> group by node_name, filespace_name
>
> Alex Paschal
> Storage Administrator
> Freightliner, LLC
> (503) 745-6850 phone/vmail
>
>
> -----Original Message-----
> From: Coats, Jack [mailto:Jack.Coats AT BANKSTERLING DOT COM]
> Sent: Wednesday, May 01, 2002 3:04 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: SQL to do q auditoccupancy?
>
>
> Someone have a guess as to how to do an SQL query to mostly duplicate the
> "query auditoccupancy" command or even "query occupancy"?
>
> ... TIA ... JC