hi geirr and bruce my hero's,

THNX! 
mi©helle
-----Original Message-----
From: Halvorsen Geirr Gulbrand [mailto:gehal AT WMDATA DOT COM]
Sent: Monday, October 07, 2002 1:59 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: q libv


Hi Michelle
try the following;
select count(*) from libvolumes where status='Scratch'

Rgds
Geirr G. Halvorsen

-----Original Message-----
From: Michelle Wiedeman [mailto:michelle.wiedeman AT MULTRIX DOT COM]
Sent: 7. oktober 2002 13:43
To: ADSM-L AT VM.MARIST DOT EDU
Subject: q libv


hi!
does anyone know how to query the library volumes and see the amount of
scratch tapes there wthout having to plough through the whole list of all
volumes?

thnx,
Michelle