Re: Query Scratch Volumes

[Braich, Raminder]

Steve,


  Try this,
     select * from libvolumes where status='Scratch'
If you need to see only the volume names
     select volume_names, status from libvolumes where status='Scratch'


> -----Original Message-----
> From: Steve Hicks [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 11:13 AM
> To:   [EMAIL PROTECTED]
> Subject:      Query Scratch Volumes
>
>  What would the syntax be for a query to only show scratch volumes?