Re: [ADSM-L] SQL for highest volume label in library
2014-12-11 10:46:47
It depends on what you mean by "highest", but assuming you mean
lexigraphically highest, this would work:
SELECT MAX(volume_name) FROM libvolumes WHERE library_name='foo'
On Thu, Dec 11, 2014 at 03:41:23PM +0000, Loon, EJ van (ITOPT3) - KLM wrote:
> Hi TSM-ers!
> Does anybody know a SQL statement to retrieve the highest volume label of all
> tapes in a library? Is it possible with one single SQL query?
> Thanks for any help in advance!
--
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine
|
|
|