Perfect.
Thank you!
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Nick Marouf
Sent: Friday, June 02, 2017 10:16 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,
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 <JBruno AT cenhud DOT 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
> jbruno AT cenhud DOT com<mailto:jbruno AT cenhud DOT com>
> Central Hudson Gas & Electric
> (845) 486-5780
>
--
PGP PUBLIC KEY
https://urldefense.proofpoint.com/v2/url?u=https-3A__keybase.io_marouf_key.asc&d=DwIBaQ&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=lLjhwVnAD0VuZ7N_yKK1k6TJ-lKBC66oi7qVEVnWbzY&s=TF993DAZK7zUSK3JyLM6otgeH13paxydM84sR-PR8Cg&e=