SQL for highest volume label in library

2014-12-11 Thread Loon, EJ van (ITOPT3) - KLM
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

Re: SQL for highest volume label in library

2014-12-11 Thread Skylar Thompson
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

Re: SQL for highest volume label in library

2014-12-11 Thread Thomas Denier
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

Re: SQL for highest volume label in library

2014-12-11 Thread David Ehresman
: [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

Re: SQL for highest volume label in library

2014-12-11 Thread Loon, EJ van (ITOPT3) - KLM
: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 +