hi geirr and bruce my hero's, THNX! miİhelle -----Original Message----- From: Halvorsen Geirr Gulbrand [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:59 PM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: 7. oktober 2002 13:43 To: [EMAIL PROTECTED] 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