Thank you.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Bommasani, Venu
Sent: Friday, June 02, 2017 10:24 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Tables in TSM database


** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.


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 AT VM.MARIST DOT EDU] On Behalf Of 
Jeannie Bruno
Sent: Friday, June 02, 2017 7:35 PM
To: ADSM-L AT VM.MARIST DOT 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
jbruno AT cenhud DOT com<mailto:jbruno AT cenhud DOT 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.