just do, from an administrative session (dsmadmc) :
     select * from syscat.tables
     select * from syscat.columns
     select * from syscat.enumtypes

     standard SQL query commands to retrieve info from any of the tables,
     such as you might have seen in earlier messages from me.

     select * from adsm.backups where node_name='BLAH' and
     filespace_name='/home' and type='ACTIVE'



______________________________ Reply Separator _________________________________
Subject: Query ADSM system catalog tables
Author:  kunalc at unix,mime/DD.RFC-822=kunalc AT PRTH.GEOBANK.PGS DOT COM
Date:    3/18/99 6:44 PM


Hello Gurus,

Could any one of you can tell me how to query the ADSM system catalog tables -
namely -
SYSCAT.TABLES
SYSCAT.COLUMNS
SYSCAT.ENUMTYPES

Thanks in advance

Regards

Kunal