Boy!  When they say there's more than one way to skin a cat its true .....

One more:

   if you sometimes accidently checkin scratches as Private
you can find them,  along with any truly Private tapes check'd in but not
mounted nor used even once with :

select volume_name,status from libvolumes where last_use is null -
and status='Private'

that 'is null' was tough to figure out for use SQL neubies !!! ....

joe.f.

Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Fri, 23 Feb 2001, Steve Hicks wrote:

>  What would the syntax be for a query to only show scratch volumes?
>