If you are only occasionally moving old volumes, you could just run a script
that builds the command and manually paste it to the command line.

select  volume_name, date(last_write_date) as "Oldest Volume"  from volumes
where last_write_date=(select min(last_write_date) from volumes)

select  'MOVE DATA ' as "Run This Command", volume_name from volumes where
last_write_date=(select min(last_write_date) from volumes)

Output:

VOLUME_NAME            Oldest Volume
------------------     -------------
WG1012                    2008-03-26


Run This Command     VOLUME_NAME       
----------------     ------------------
MOVE DATA            WG1012   


Bob
     

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bjørn Nachtwey
Sent: Friday, January 09, 2009 2:35 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Question on automated data move for tapes not accessed
for a certain time: conclusion

dear all,

thanks for your answers, so i think i'll only touch the 3590-tapes used
for archive, because the tapes are 9 years old :-)



David E Ehresman wrote:
> I have a simplistic korn shell script that does this that I could share
> with you if you are interested.
>
> David Ehresman
>   
sure, i'll compare it with mine and may improve it.


thanks,

Bjørn


-- 
########################################################################
Dipl.-Ing. Bjørn Nachtwey
Technische Universität Carolo-Wilhelmina zu Braunschweig
Gauss-IT-Zentrum (GITZ) -- Abteilung Server
Hans-Sommerstraße 56,  38106 Braunschweig
Telephon: +49 (0)531 / 391 - 5535
TeleFax:  +49 (0)531 / 391 - 5549
Mobil:    +49 (0)163 / 639   4804
http://www.tu-braunschweig.de/it
mailto: b.nachtwey AT tu-bs DOT de
mailto: c0034031 AT tu-bs DOT de
########################################################################
PGP-Schluessel:
http://www-public.tu-bs.de:8080/~nachtwey/bjoern_nachtwey.asc
PGP-Fingerprint:
B472 526A A903 4AEB 9269 EC0B 9CDE 7465 CE87
########################################################################

This electronic transmission and any documents accompanying this electronic 
transmission contain confidential information belonging to the sender.  This 
information may be legally privileged.  The information is intended only for 
the use of the individual or entity named above.  If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or the taking of any action in reliance on or regarding the contents of this 
electronically transmitted information is strictly prohibited.