Replying to: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> (Mon, 7 Sep
1998 14:19:52 +0200)

>Hi ADSM-ers!
>I have two questions:
[...]
>2) How do I query ADSM for the tape label of the most recent database
>backup?

Try:

select volume_name from volhistory \
  where date_time in ( \
    select max(date_time) from volhistory \
      where type = 'BACKUPFULL')


--
Rui Malheiro,
Rui Malheiro,
6 Mil - Tecnologias de Informacao
URL: <http://www.6mil.pt/>