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 <[email protected]> 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 > [email protected]<mailto:[email protected]> > Central Hudson Gas & Electric > (845) 486-5780 > -- PGP PUBLIC KEY https://keybase.io/marouf/key.asc
