Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2011 @ 10:08:33 GMT


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

Subj:		Re: MLPPI on date field

From:		Mukardamwala Suhel

Hi,

I think this could help.

     CREATE TABLE claims (
     claim_id INTEGER NOT NULL,
     claim_date DATE NOT NULL,
     state_id BYTEINT NOT NULL,
     claim_info VARCHAR(20000)
     NOT NULL)
     PRIMARY INDEX (claim_id)
     PARTITION BY (
     RANGE_N (claim_date BETWEEN
     DATE '2001-01-01' AND DATE
     '2007-12-31'
     EACH INTERVAL '1' MONTH),
     RANGE_N(state_id BETWEEN 1
     AND 75 EACH 1))
     UNIQUE INDEX (claim_id);

Regards,

Suhel Mukardamwala