How about:

select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'

Steven




Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
[ADSM-L] select statement to display readonly and filling tapes




Caterpillar: Confidential Green Retain Until: 15/12/2010



Hi

I am trying to add "filling" tapes to this select statement and I am
having no luck does anyone have a select statement that shows this?



I already have most of the statement below i just need to add "filling"
to the statement

select VOLUME_NAME,ACCESS from volumes where access ='READONLY'


thanks for any help