Hello Bo,

My "q occu" shows both Bkup and Arch files Types.

and even

adsm> select distinct type from occupancy

shows only the Arch type

TYPE
------------------
Arch
Arch


I want use Ms Office with ODBC driver to see some statistics.
My server is Version 3.1.0.2 under AIX 4.2

J.Glauer



On Feb 4,  7:55am, Bo Ossinger wrote:
> Subject: Re: ADSM_SQL_V3
> At 02:49 PM 2/4/98 +0000, J. Glauer wrote:
> >  commands: q occu
> >  and       select * from occupancy
> >  The results should be the same.
> >  select shows no type=Bkup
>
> Are you sure it's not just sorting output based on Type?  We have no Arch
> types, but the select shows me the same Bkup records as a "q occ" command.
>
>
> ====================================================================
> Bo R. Ossinger                 email: ossinger AT wsu DOT edu
> Washington State University    phone: 509-335-0920
> Information Technology         fax:   509-335-6635,,,50920
> Production Support Systems     http://www.wsu.edu/prod_supp/Pss.html
> PO Box 641222
> Pullman, WA  99164-1222
> ====================================================================
>-- End of excerpt from Bo Ossinger