I don't think there's a day goes by that I don't use this document as a
reference; it has been enormously helpful.

Some people may need to be reminded, though, that these are the tables from
ADSM 3.1.something.
Versions 3.7 and 4.1 have added some tables and some columns.

You can get the listings yourself of the tables for your ADSM server with:

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

> -----Original Message-----
> From: Andy Raibeck [SMTP:Andrew_Raibeck AT TIVOLI DOT COM]
> Sent: Thursday, November 09, 2000 6:08 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: find a file in tivoli
>
> > Tom was kind enough to send me the document.  I'm afraid that it's a
> fairly
> > useless document.  It doesn't teach anything about SQL; any basic
> tutorial
> > on SQL would actually be better.  The only moderately good thing about
> the
> > document is that it contains a complete listing of syscat.columns, but
> even
> > that isn't too useful because it's not grouped by tabname.  In fact, I
> just
> > figured out why the document looked familiar.  It's exactly the same as
> the
> > output of the "help select" command from the ADSM Admin command line.
>
> I am sorry you did not find it useful. However, it is not intended to be a
> tutorial, but a reference. I do not know what the cover of the copy you
> have
> looks like, but I did indicate that it is a work in progress.
> Unfortunately
> it's been quite some time since I wrote it, and I have yet to find the
> time
> to get it up to date and add some more stuff.
>
> Background: I was trying to learn SQL myself (the SELECT command), and had
> the
> idea to write a presentation as I learned. I presented this at the
> University
> of Karlsruhe's ADSM Symposium in 1998, and again at a subsequent SHARE.
> The
> presentation was the tutorial part, and as an added "bonus", I included
> the
> document that you have a copy of. It was/is a "pet project" of mine to
> fill
> the document out at some future time, but I just haven't been able to find
> the
> time to get to it. As a start for the doc you have, I "borrowed" the HELP
> information from ADSM itself, just as you have surmised, and added some
> appendices with what I hoped would be more useful reference information
> regarding the tables and columns available, and the supported SQL
> functions.
>
> Eventually I would like to add a little more meat to the document,
> including
> an improved tutorial and info on the ODBC driver. The HELP info would
> either
> no longer be necessary, or I'd relegate it to an appendix.
>
> It's all a matter of trying to eke out a few more hours in the day...
>
> Best regards,
>
> Andy
>
> Andy Raibeck
> IBM/Tivoli
> Tivoli Storage Manager Client Development
> e-mail: andrew.raibeck AT tivoli DOT com
> "The only dumb question is the one that goes unasked."