Archives of the TeradataForum
Message Posted: Fri, 21 Dec 2007 @ 14:12:44 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|