Archives of the TeradataForum

Message Posted: Tue, 04 Dec 2007 @ 09:24:25 GMT

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

I think you are duplicating existing functionality. There is a DBC table called dbc.children that will meet your needs for the relationships.

You would also need to use recursion as previously stated to determine all relationships.

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