Re: SQL Querries
1999-10-26 07:41:21
Use a postscript viewer such as Ghostscript to view .ps files or if you're
lucky enough to have access to Acrobat Distiller you can make the .ps file
into a .pdf file.
Nathan
-----Original Message-----
From: Roland Bender [SMTP:BENDERR AT ING.BOEHRINGER-INGELHEIM DOT COM]
Sent: Tuesday, October 26, 1999 3:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: AW: SQL Querries
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
|
|
|