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?
>