Archives of the TeradataForum

Message Posted: Fri, 27 Jan 2006 @ 21:15:11 GMT

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

Ok, cool! So I added the postscript, calling the table name macro:

     ALTER TABLE %TableName
           MODIFY PRIMARY INDEX
           PARTITION BY CASE_N(C2T_Expir_Dt = '9999-12-31', NO CASE);

Into the ERwin definition of the table, and it works. But as I understand it, ERwin has a whole set of macros that do things like "For Each Column" etc. I'm wondering if it could do looping through the columns and pick the appropriate ones for the partitioning statement, depending on the value of a UDP. More than that, I'm wondering if you can somehow alter the "default" table generation macros themselves and get things like Multiset (yuck, yuck, icky!) or allowing compression on a column in the PK (as opposed to one in the PI!). Anyway, let the coding begin!

iv

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