Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 14:12:44 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Finding the set/multiset property of a table in the data dictionary
 
From:   Dieter Capek

Hello forum,

Can you please advise how the data dictionary (e.g. dbc.tvm) shows if a table is set or multiset?

I am aware of a previous post on this issue at www.teradataforum.com/teradata/20000627_194101.htm and have tried to use tvm.checkopt without success.

Perhaps tvm.checkopt was a valid multiset table indicator in 2000 (when the mentioned post was written). A week ago I did check this and found multiset tables having both Y and N values on a TD Rel 5.0 system. My impression is that due to the lot of functionality added tvm.checkopt is not a valid indicator for the multiset property any longer.

I have tried

     SELECT dbase.DatabaseName,
            tvm.TVMName(NAMED TableName),
            tvm.Version(FORMAT 'zzzz(9)'),
            tvm.TableKind,
            tvm.ProtectionType,
            tvm.JournalFlag,
            COALESCE(DB1.DatabaseName,DBC.tvm.CreatorName) (named CreatorName),
            tvm.RequestText,
            substr( tvm.requesttext, 1,20 ),
            tvm.checkopt

     FROM DBC.tvm
          LEFT OUTER JOIN DBC.Dbase DB1
                       ON DBC.tvm.CreatorName = DB1.DatabaseNameI
          LEFT OUTER JOIN DBC.Dbase DB2
                       ON DBC.tvm.LastAlterUID = DB2.DatabaseID,
          DBC.dbase

         WHERE tvm.DatabaseId = dbase.DatabaseId
           and tablekind = 'T';

Can you please advise a better approach?


Thank you!

Dieter Capek



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016