Hello Everyone!

I am trying to get a count of how many scratch tapes I have in NASLIB.  I
issue the following command, but it comes up with 0.  Would you happen to
know what I am doing wrong?  Thanks!

select count(*) as "NAS Scratch Tape Count" from libvolumes where
library_name='NASLIB' and status='SCRATCH'

Library Name  Volume Name  Status      Owner       Last Use   Home E
Device
                                                              lement   Type

------------  -----------  ----------  ----------  ---------  -------
------
NASLIB        N00000       Scratch

NASLIB        N00001       Scratch

NASLIB        N00002       Scratch

NASLIB        N00003       Scratch

NASLIB        N00004       Scratch

NASLIB        N00005       Scratch

NASLIB        N00006       Scratch

NASLIB        N00007       Scratch

NASLIB        N00010       Private                 Data

NASLIB        N00017       Scratch

NASLIB        N00018       Scratch

NASLIB        N00019       Scratch

NASLIB        N00020       Scratch

NASLIB        N00021       Scratch

NASLIB        N00022       Scratch

NASLIB        N00023       Scratch

NASLIB        N00024       Scratch

NASLIB        N00025       Scratch

NASLIB        N00026       Scratch

NASLIB        N00027       Scratch


********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************