I do a daily query and OS/2 rexx commands on the onsite tapepool and
offsite tapepool.  I query both tapepools to a file, then use rexx to add
up the tapes in each.  I need to convert the daily reports  to use SELECT
statements via the TSO client.

If I use Select, from STGPOOL,   PCT_MIGR* MAXSCRATCH ,  I get an accurate
number of tapes used in the primary tape pool.
How do I get an accurate count of tapes in my offsite copy tapepool?
If the only way is to do some sort of listing them and summing them, is
there an easy way to do that with a Select?

My alternative is to add a SAS step to the job, and add them up with SAS..
I was just hoping I could do the entire report with Select statements..

Thanks!
Julie