Archives of the TeradataForum

Message Posted: Thu, 01 Feb 2001 @ 21:54:19 GMT

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

Hello, out there!

Has anyone else (besides Len Gavin, that I know of) extended the DIM in Metadata Services? I was always curious about what would happen if you do that and try and run the automagic updating that can occur with that new VProc that extracts from DBC into MDS. Anyone have any other experiences with Metadata Services they want to talk about?

I also want to know what happens when you do the classic INSERT INTO a new table, rename the old to something else, and then RENAME the new table to the old name. Having gone through the trouble of doing COMMENT ON TABLE and ON COLUMN and then forgetting (forgetting? I shouldn't have to!) to put the comments into the scripts that do the INSERT/RENAME processes and therefore loosing the COMMENTs, I'd hate to have the Repository in MDS loose the "metadata" in that same process.

Anyway, right now this is just "thereorectically speaking", but if you've got the experience, I've got the ear.

iv

Frank C. Martinez IV

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