Perhaps this would also work:

Select VOLUME_NAME from VOLUMES where status='FILLING' and access='READONLY'

El nov 15, 2010 11:30 a.m., "Keith M Williams" <kwilliam AT us.ibm DOT com>
escribió:

How about  this for TSM:

select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS
from media where VOLUME_NAME='FILLING'

Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwilliam AT us.ibm DOT com




From:

Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
To:
ADSM-L AT vm.marist DOT edu
Date:
11/15/2010 07:40 AM
Subject:

select statement to display readonly and filling tapes
Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>




Hi

I am trying to add "filling" tapes to this select statement and I am
having no luck does anyo...