On Fri, 29 Jun 2001 10:02:59 -0500, you wrote:
>Basically, I want to do a Q VOLUME and look for any tapes that are below 40%
>utilized and then compare the results to a Q LIBV 3575LIB command.  If I get
>a hit in both queries, I want to know the tape number.  Any suggestions?

Try this:

select volume_name,stgpool_name,pct_utilized from volumes where
pct_utilized<40 order by pct_utilized

--
Mark Stapleton (stapleton AT berbee DOT com)
Mark Stapleton (stapleton AT berbee DOT com)