Re: select statement to display readonly and filling tapes

2010-11-17 Thread Timothy Hughes
7; ANS8001I Return code 3. tsm: TSMCORE> tsm: TSMCORE> On 11/15/2010 8:48 AM, Steven Langdale wrote: How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughes Sent by: "ADSM: Dist Stor Manager"

Re: select statement to display readonly and filling tapes

2010-11-17 Thread Timothy Hughes
ann 250-585-3711 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Guido Martínez Sent: Monday, November 15, 2010 09:35 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select statement to display readonly and filling tapes Perhaps this would al

Re: select statement to display readonly and filling tapes

2010-11-16 Thread J. Pohlmann
[mailto:ads...@vm.marist.edu] On Behalf Of Guido Martínez Sent: Monday, November 15, 2010 09:35 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select statement to display readonly and filling tapes Perhaps this would also work: Select VOLUME_NAME from VOLUMES where status='FILLING' and

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Maurice van 't Loo
SS from volumes where access='READONLY' or >> status='FILLING' >> >> Steven >> >> >> >> >> Timothy Hughes >> Sent by: "ADSM: Dist Stor Manager" >> 15/11/2010 13:39 >> Please respond to >> "ADSM: Dist S

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Thomas Denier
-Timothy Hughes wrote: - >I tried that command failed, and also I want to select the >"readonly" >tapes that say "filling" also. So I replaced the "or" with "and". >this >command failed also > >tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' >or >status='FILLING'

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Guido Martínez
27;, 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 To: ADSM-L@vm.marist.edu Date: 11/15/2010 07:40 AM Subject: select statement to displ

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Keith M Williams
: Timothy Hughes 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" Hi I am trying to add "filling" tapes to this select statement and I am having no luck does anyone have a select

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Heinz Flemming
According to Timothy Hughes: > thanks steve! > > I tried that command failed, and also I want to select the "readonly" > tapes that say "filling" also. So I replaced the "or" with "and". this > command failed also > > tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' or > status

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Guido Martínez
='READONLY' or status='FILLING' Steven Timothy Hughes Sent by: "ADSM: Dist Stor Manager" 15/11/2010 13:39 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] select statement to display readonly and filling tapes

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Timothy Hughes
ngdale wrote: How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughes Sent by: "ADSM: Dist Stor Manager" 15/11/2010 13:39 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc

Re: select statement to display readonly and filling tapes

2010-11-15 Thread Steven Langdale
How about: select VOLUME_NAME,ACCESS from volumes where access='READONLY' or status='FILLING' Steven Timothy Hughes Sent by: "ADSM: Dist Stor Manager" 15/11/2010 13:39 Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subj

select statement to display readonly and filling tapes

2010-11-15 Thread Timothy Hughes
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'