Scott,

Look in the ADSM V3 Administrator's Reference manual under the 'select'
statement.  You will find  a very small amount of information about
SYSCAT.TABLES, SYSCAT.COLUMNS, and SYSCAT.ENUMTYPES.  These are the tables
you need to query to get information about the tables and variables in
those tables that you can query.




Scott Fluegge <sfluegge AT VENATORGROUP DOT COM> on 04/27/99 08:03:43 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: Ronald Heflin/Chicago/IBM)
Subject:  SQL Querries





Does anybody have a list of all of the table and variable names?  I would
like
to put together some SQL querries but I can't find a list of tables
anywhere!!

Thanks,

Scott