Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2003 @ 00:56:10 GMT

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

To the best of my knowledge there are no views in DBC to support the references information within Teradata.

WinDDI can achieve this by searching the CreateText in dbc.tvm. Below is an example of how this can be accomplished.

SELECT DatabaseName,TVMName,TableKind AS "Type" FROM dbc.TVM T,dbc.dbase D WHERE D.DatabaseId=T.DatabaseId AND CreateText LIKE '%"DBC"."Dbase"%' ORDER BY 1,2

The catch is that the WinDDi user must have select privilege on DBC.TVM and DBC.Dbase as the example above shows in the "from" clause...

Other issues that you will run into are that you may not return all of the references that you are looking for. Most objects do not use fully qualified names. Some object constructs use "FROM DBASE" where others may use "FROM DBC.DBASE D" as an alias.

Other issues are multiple object references within the object construct so you may have a fully qualified name but it is missed because of this syntax "FROM DBC.DBASE, DBC.TVM" this will not pick up the reference because you were looking for "dbc.dbase" and not "dbc.dbase," (notice the "," at the end)

At this point in time, you have to get creative, capture every object ddl and sift through with the right questions to achieve your goals.

Chris Coffing
Senior Vice President
Coffing Data Warehousing
www.coffingdw.com

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