Archives of the TeradataForum

Message Posted: Tue, 12 May 2009 @ 12:15:26 GMT

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

I can't answer your question, but I wanted to note one thing about your table definition.

     > Column1   INTEGER      NOT NULL      ,...
     > PARTITION BY           RANGE_N(Column1  BETWEEN 200612  AND 200712 EACH 1)

This will create 101 partitions for 200612, 200613, 200614, ... 200699, 200700, 200701, etc. That's probably not what you want, right?

If you need codes in your database to represent months, I suggest something like (year - 1990) * 12 + month. This will fit into a smallint with no gaps between months.

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