ADSM-L

Re: TSM database documentation ?

2001-07-20 11:16:39
Subject: Re: TSM database documentation ?
From: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Date: Fri, 20 Jul 2001 11:17:00 -0400
To get this info use select statements.

select * from syscat.tables
select * from syscat.columns
select * from syscat.enumtypes

This will give you lots of info and you can use to see what
is in each table, etc.  You can modify selects to get just
certain info instead of the whole thing.

That's it in a nutshell.



David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5525
david.longo AT health-first DOT org


>>> ray.dmochowski AT SPCORP DOT COM 07/20/01 11:00AM >>>
While we await an update to the ER diagram for TSM, can anyone
direct me to current documentation about the tables in the TSM Database,
including descriptions of each, with the names and descriptions of each
data coulmn included in the tables?

Ray Dmochowski  <ray.dmochowski AT spcorp DOT com>
(908) 740-3261
Schering-Plough Research Institute
Kenilworth, NJ 07033, U.S.A.



***************************************************************
 This message and any attachments is solely for the intended recipient. If
you are not the intended recipient, disclosure, copying, use, or
distribution of the information included in this message is prohibited --
please immediately and permanently delete this message.



"MMS <health-first.org>" made the following
 annotations on 07/20/01 11:21:46
------------------------------------------------------------------------------
---
This message is for the named person's use only.  It may contain This message 
is for the named person's use only.  It may contain confidential, proprietary, 
or legally privileged information.  No confidentiality or privilege is waived 
or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard 
copies of it, and notify the sender.  You must not, directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you are 
not the intended recipient.  Health First reserves the right to monitor all 
e-mail communications through its networks.  Any views or opinions expressed in 
this message are solely those of the individual sender, except (1) where the 
message states such views or opinions are on behalf of a particular entity;  
and (2) the sender is authorized by the entity to give such views or opinions.

==============================================================================
<Prev in Thread] Current Thread [Next in Thread>