AW: SQL Querries
1999-10-26 04:23:19
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
|
|
|