Thank you Kathleen!  That was my mistake and it is working now.  : )

Joni




             "Kathleen
             Hallahan"
             <Kathleen_Hallaha                                          To
             n AT FREDDIEMAC DOT COM>         ADSM-L AT VM.MARIST DOT EDU
             Sent by: "ADSM:                                            cc
             Dist Stor
             Manager"                                              Subject
             <[email protected]         Re: LIBVOL Scratch Count
             .EDU>


             04/21/2005 11:20
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






This is probably because of a minor annoyance with the select query.  While
most of the tables have their values as all caps, the libvolumes table does
not.  Try this:

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

Good luck!

Kathleen




             "Joni Moyer"
             <joni.moyer@HIGHM
             ARK.COM>                                                   To
                                       ADSM-L AT VM.MARIST DOT EDU
  Sent by : "ADSM: Dist Stor                                            cc
  Manager"
  <ADSM-L AT VM.MARIST DOT EDU>                                           
Subject
                                       LIBVOL Scratch Count

             04/21/2005 10:56
             AM


             Please respond to
              "ADSM: Dist Stor
                  Manager"
              <[email protected]
                   T.EDU>






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