Christian,
I have been down this road.  There is no publication with what you are looking 
for.  As mentioned previously, the HELP option and Admin guide is the best your 
going to get.  You will have to look at each table and the columns associated 
with the tables.  Then create your own SQL statements.  I took me a while, but 
this is the path I took.  And actually the research doing this has made my 
administration faster and more detailed.

Good Luck,
Danny

Danny Groulx
Project Manager
SALEM GROUP | WE PUT DATA IN ITS PLACE
465 Corporate Square Drive
Winston-Salem, NC  27105
P   336 744 5999
F   336 661 3400
M  919 602 3407 (preferred #)
danny.groulx AT salemgroup DOT com <outbind://8/danny.groulx AT salemgroup DOT 
com> 


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Christian Svensson
Sent: Friday, April 25, 2003 10:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Select manuals


                                                                                
                               
                                                                                
                               
                                                                                
                               


Thanks John!
But I need to go realy, realy deep in the SQL92/SQL93 select commands and
understand exactly how everything work.
I want to be a expert on all select statement.
What I searching for is a documentation who explain each parametar what is
does and what you can do with it way you use it.
And the link I got from Richard is good document. But that not enough for
me.
It´s should be perfect if there is a RedBook for just only TSM Select
statement. Who explain everything.

There is maybe a idea for everyone who write alot of books. A Select
statement bible. :-)

Best Regard / Med vänlig hälsning
Christian Svensson

…………………………………………………………………………....
Cristie Nordic AB
Box 2             Phone : +46-(0)8-718 43 30
SE-131 06 Nacka         Mobil : +46-(0)70-32 15 77
Sweden                  eMail : Christian.svensson AT cristie DOT se


Visit : Gamla Värmdövägen 4, Plan 2
web : www.cristie.com
…………………………………………………………………………....


                                                                                
                                                        
                      "Talafous, John                                           
                                                        
                      G."                      To:       ADSM-L AT VM.MARIST 
DOT EDU                                                           
                      <Talafous@TIMKEN.        cc:                              
                                                        
                      COM>                     Subject:  Re: SQL Select manuals 
                                                        
                      Sent by: "ADSM:                                           
                                                        
                      Dist Stor                                                 
                                                        
                      Manager" <ADSM-                                           
                                                        
                      L AT VM.MARIST DOT EDU>                                   
                                                               
                                                                                
                                                        
                                                                                
                                                        
                      2003-04-25 15:39                                          
                                                        
                      Please respond to                                         
                                                        
                      "ADSM: Dist Stor                                          
                                                        
                      Manager"                                                  
                                                        
                                                                                
                                                        
                                                                                
                                                        




Richard Sims' reply was a very good one. If you need more information, the
only other thing I can think of is to start an admin command line session
and trap the output of the HELP SELECT command. This will give you the
syntax of TSM's SQL SELECT statement.

Additionally, you can get documentation about the TSM SQL tables with these
commands:

Select * from tables
Select * from columns
Select * from enumtypes

Piece all these together and you have the bulk of the documentation for the
TSM SQL environment.

Happy studying, and enjoy the sunshine!!!

John G. Talafous              IS Technical Principal
The Timken Company            Global Software Support
P.O. Box 6927                 Data Management
1835 Dueber Ave. S.W.         Phone: (330)-471-3390
Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
talafous AT timken DOT com           http://www.timken.com



**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**********************************************************************