Thanks Richard!
But that is not enough for me. I need to go deeper in to the select
command.

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


                                                                                
                                                        
                      Richard Sims                                              
                                                        
                      <rbs AT BU DOT EDU>             To:       ADSM-L AT 
VM.MARIST DOT EDU                                                           
                      Sent by: "ADSM:          cc:                              
                                                        
                      Dist Stor                Subject:  Re: SQL Select manuals 
                                                        
                      Manager" <ADSM-                                           
                                                        
                      L AT VM.MARIST DOT EDU>                                   
                                                               
                                                                                
                                                        
                                                                                
                                                        
                      2003-04-25 13:25                                          
                                                        
                      Please respond to                                         
                                                        
                      "ADSM: Dist Stor                                          
                                                        
                      Manager"                                                  
                                                        
                                                                                
                                                        
                                                                                
                                                        




>...where I can read about all select commands for TSM?

Well, there is only one Select command.  :-)  The Admin Ref manual has
the basics.  The ADSM/TSM Technical Guide redbooks carry a perpetual
appendix covering TSM SQL.   Near the bottom of
http://people.bu.edu/rbs/ADSM.QuickFacts
I keep a list of web sites that I have found useful for SQL usage.
Always remember that SQL for the TSM database is very restricted,
and often involves a lot of overhead in terms of db work space and
execution time.

  Richard Sims, BU