Make a note of the casing of the word "Scratch" in your SELECT statement (don't ask me why it is in mixed case...).
Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-04-21 07:56:05: > 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 > [EMAIL PROTECTED] > ********************************
