at the ADSM prompt type "select * from syscat.tables".  This will give you all
of the tables.  Typing "select * from syscat.columns" will give you the columns
in each table.  Hope this is the info you are looking for.

Shawn Dahm
sdahm AT mcleodusa DOT com





wawork Wash <wawork AT HOTMAIL DOT COM> on 07/14/2000 10:28:03 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Shawn Dahm/MCLEOD)
Subject:  Where do I find the data model for ADSM?




Hello,
  Our Unix admin folks run the ADSM at our site.  Unfortunately they refuse
to learn SQL.  I need to query the ADSM database.  Therefore, I need a list
or diagram of tables and their fields that make up the ADSM database.  Can
someone point me in the direction of either on-line documentation or tell me
which manual I need to request from our Unix administrator?

Thanks,
  Randy
  wawork AT hotmail DOT com
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com