Archives of the TeradataForum

Message Posted: Wed, 27 Mar 2013 @ 11:33:03 GMT

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

Vijay Mani wrote:

          > CREATE MULTISET TABLE Table1 ,NO FALLBACK (
          > Field1 DATE FORMAT 'yyyy-mm-dd' NOT NULL,
          > Field2 DECIMAL(18,0) NOT NULL)
          > PRIMARY INDEX  pi1(Field2)
          > PARTITION BY RANGE_N(Field1 BETWEEN '2011-06-01' AND '2013-12-31' EACH
          > INTERVAL '1' DAY );

Which release?

In TD14 there's a new PartitioningColumn in dbc.ColumnsV.

Before there's PartitionColumn in my multi-purpose stats query :-)

developer.teradata.com/...

Dieter

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