ADSM-L

Re: [ADSM-L] select statement to display readonly and filling tapes

2010-11-15 09:19:30
Subject: Re: [ADSM-L] select statement to display readonly and filling tapes
From: Guido Martínez <guidomar17 AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 15 Nov 2010 11:18:28 -0300
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" <Steven.Langdale AT cat DOT com>
escribió:

How about:

select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'

Steven




Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
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...