Hi Randy,
try this from the adsm prompt
select * from syscat.columns order by tabname, colname

Hope this helps you out.
Greg



At 08:28 AM 7/14/00 -0700, you wrote:

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

Greg Dick ( gregoryd AT isc.upenn DOT edu ) phone: (215)573-4698
Systems Programmer
ISC Technical Services fax: (215)898-0386
University of Pennsylvania
3401 Walnut Street - Suite 265C
Philadelphia PA 19104-6228