ADSM-L

Re: SQL Querries

1999-10-26 07:41:21
Subject: Re: SQL Querries
From: Nathan King <nathan.king AT USAA DOT COM>
Date: Tue, 26 Oct 1999 06:41:21 -0500
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
<Prev in Thread] Current Thread [Next in Thread>