How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING'
Steven Timothy Hughes <[email protected]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 15/11/2010 13:39 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] 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
