Re: Query Scratch Volumes

Fri, 23 Feb 2001 08:22:23 -0800 

select volume_name from libvolumes where status = 'Scratch' 
  will list all scratch volumes
  We use
select count(*) from libvolumes where status = 'Scratch'
  to get the number of scratch tape

[EMAIL PROTECTED]

>>> [EMAIL PROTECTED] 02/23/01 10:13AM >>>
 What would the syntax be for a query to only show scratch volumes?

Reply via email to