Hi Richard, 

its me again.

I had a look at previous postings and found the following for you:

just do, from an administrative session (dsmadmc) : 

select * from syscat.tables 
select * from syscat.columns 
select * from syscat.enumtypes 

standard SQL query commands to retrieve info from any of the tables, such as
you might have seen in earlier messages from me. 

select * from adsm.backups where node_name='BLAH' and filespace_name='/home'
and type='ACTIVE' 


Hope that helps.

Bye 

Roland

> -----Ursprüngliche Nachricht-----
> Von:  Gerd Leibrock [SMTP:Gerd.Leibrock AT KNO-BS DOT DE]
> Gesendet am:  Dienstag, 26. Oktober 1999 09:56
> An:   ADSM-L AT VM.MARIST DOT EDU
> Betreff:      AW: SQL Querries
> 
> Hello Richard,
> 
> how can I view a *.ps-file?
> 
> Mit freundlichem Gruß
> Gerd Leibrock
> 
> Koch, Neff & Oetinger & Co. GmbH
> Schockenriedstr. 37
> 70565 Stuttgart
>  
> Tel: +49 711 7860-2393
> Fax: +49 711 7860-2811
> Gerd.Leibrock AT kno-bs DOT de
> http://www.buchkatalog.de
> 
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: Richard Sims [mailto:rbs AT BU DOT EDU]
> Gesendet am: Montag, 25. Oktober 1999 21:39
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: Re: SQL Querries
> 
> > >Does anybody have a list of all of the table and variable names?  I
> would
> like
> > >to put together some SQL querries but I can't find a list of tables
> anywhere!!
> 
> Perhaps: http://www.uni-karlsruhe.de/~rz57/ADSM/3rd/handouts/raibeck.ps