Hi, I've found these to be helpful select * from syscat.tables select * from syscat.columns select * from syscat.enumtypes Select colname from syscat.columns where tabname='OCCUPANCY' and tabschema='TSMDB1'
On Fri, Jun 2, 2017 at 8:05 AM, Jeannie Bruno <jbr...@cenhud.com> wrote: > Hello. Ya know how in TSM one can write queries against a Table on the > TSM database (ie: select sum from SUMMARY or select * from NODESVIEW). > > Does anyone know the command or query that tells me all the Table names on > the database? I can't find.... > > > ____________________ > Jeannie Bruno > Senior Systems Analyst > jbr...@cenhud.com<mailto:jbr...@cenhud.com> > Central Hudson Gas & Electric > (845) 486-5780 > -- PGP PUBLIC KEY https://keybase.io/marouf/key.asc