> 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."