Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 09:10:38 GMT

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

<-- Anonymously Posted: Tuesday, November 30, 2004 18:40 -->

Current version 4.xx.xx, whatever, does not.

Not sure if the following works in 3.5.2, but give it a try.

For PPI, we use an Index UDP on the primary index named PPI which we populate with the "partition expression", ie. RANGE_N ( BusinessDate

     BETWEEN
     '2003-01-01 AND '2004-12-31' EACH INTERVAL '1' MONTH ).

We have a table-level postscript which simply generates the DDL: (simplified sample)

     ALTER TABLE %TableName
     MODIFY PRIMARY INDEX
     PARTITION BY %IndexProp(PPI);

which generates as

     ALTER TABLE MyTable
     MODIFY PRIMARY INDEX
     PARTITION BY RANGE_N ( BusinessDate BETWEEN '2003-01-01 AND '2004-12-31'
     EACH INTERVAL '1' MONTH );

Note this only works on an empty table, that is it only works for original CREATE DDL statements.

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