>Is there a way to tell how many days a tape has been in the pending state.

Just to add to the other fine suggestions...
I do a conjunctive lookup from STGPOOLS to also get the Reusedelay
value, just for reference (takes a little longer):

SELECT CHAR(VOLUME_NAME,6) AS "Volume", CHAR(STGPOOL_NAME,26) AS "Storage Pool  
            ", -
 SUBSTR(CHAR(PENDING_DATE),1,19) AS "Pending Date       ", -
 (SELECT REUSEDELAY FROM STGPOOLS WHERE STGPOOL_NAME=VOLUMES.STGPOOL_NAME) AS 
"Reusedelay" -
 FROM VOLUMES WHERE STATUS='PENDING'

   Richard Sims, BU