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" <[email protected]> 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 [email protected] From: Timothy Hughes <[email protected]> To: [email protected] Date: 11/15/2010 07:40 AM Subject: select statement to display readonly and filling tapes Sent by: "ADSM: Dist Stor Manager" <[email protected]> Hi I am trying to add "filling" tapes to this select statement and I am having no luck does anyo...
