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" <kwill...@us.ibm.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 kwill...@us.ibm.com From: Timothy Hughes <timothy.hug...@oit.state.nj.us> To: ADSM-L@vm.marist.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@vm.marist.edu> Hi I am trying to add "filling" tapes to this select statement and I am having no luck does anyo...
