Archives of the TeradataForum

Message Posted: Thu, 18 Jun 2009 @ 09:33:16 GMT

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

hi all,

I need to be able to load the CREATE statement for each table into another table with some manipulation of the values - i tried using dbc.tables.requestText but this appears to be last the DDL run on the table.

Basically I want to be able to load the results of SHOW TABLE for a list of tables into a varchar field in another table.

I tried macros + procedures with no success.

Thanks!

Chaim

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