If you only want to find tapes in "FILLING" this select should be more than enough:
Select VOLUME_NAME from VOLUMES where status='FILLING' El nov 15, 2010 10:50 a.m., "Steven Langdale" <[email protected]> escribió: 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 anyo...
