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!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
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 +, Loon, EJ van (ITOPT3) - KLM wrote:
Hi TSM-ers!
Does anybody know a SQL statement to
volume label in library
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!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
: [ADSM-L] SQL for highest volume label in library
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!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
:45
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL for highest volume label in library
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 +