Hi Jeannie,
Please try below.
To display list of Table names
select * from syscat.tables
To display columns from all the tables
select * from syscat.columns
To display list of columns from a particular table.
SELECT COLNAME FROM syscat.columns WHERE tabname=' TABNAME'
Ex:
SELECT COLNAME FROM syscat.columns WHERE tabname='LIBVOLUMES'
SELECT COLNAME FROM syscat.columns WHERE tabname='ASSOCIATIONS'
SELECT COLNAME FROM syscat.columns WHERE tabname='ACTLOG'
Hope this helps.
Best Regards,
_____________________________________________
Venu P Bommasani
Capgemini Technology Services India Limited / Bangalore
CONA TSM Backup & Restore
Mobile: +91 7795 213 309 / Oncall: +1 602 586 3532
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Jeannie Bruno
Sent: Friday, June 02, 2017 7:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Tables in TSM database
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
This message contains information that may be privileged or confidential and is
the property of the Capgemini Group. It is intended only for the person to whom
it is addressed. If you are not the intended recipient, you are not authorized
to read, print, retain, copy, disseminate, distribute, or use this message or
any part thereof. If you receive this message in error, please notify the
sender immediately and delete all copies of this message.
