I don't have a list of handy commands.  I suggest becoming familiar
with whats in the adsm sql database.  Sql databases are self defining,
if you know the starting point you can explore the whole thing.  For
adsm, the starting point is --

select * from syscat.tables

The next step would be --

select * from syscat.columns

Pay attention to the remarks column.

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <30MAR99.16898925.0070.MUSIC AT MUSICA.MCGILL DOT CA>, on 03/30/99
In <30MAR99.16898925.0070.MUSIC AT MUSICA.MCGILL DOT CA>, on 03/30/99
   at 03:38 PM, "Mark Brown (CC Operations Supervisor)" <CCMB AT MUSICA.MCGILL 
DOT CA> said:

>Hello,

>I am a newbie when it comes to SELCT commands for querying my MVS os390
>ADSM v3 server. Is there a place where I can download "sample" select
>commands? I have used up the samples in the ADSM manual.

>In particular I would like a command that can tell me which tapes a nodes
>files are on WITHOUT mounting a tape.



>Thank You,
>  Mark Brown, Operations Supervisor
>  McGill University, Computing Centre
>  Phone (514) 398-2321
>  E-Mail --> ccmb AT musica.mcgill DOT ca
>  Home Page --> http://mbrown.cc.mcgill.ca