PPI multi partition Issue

Database

PPI multi partition Issue

Dear All,

When I try to modify the PI as below I receive an error message like "Code = 3706: se] Syntax error: expected something between ',' and the 'BETWEEN' keyword.". May I know what is the cause of this issue and How can I rectify the same.

ALTER TABLE AR_ADJ MODIFY PRIMARY INDEX AR_ADJ_NP

PARTITION BY RANGE_N(Per_Ym

BETWEEN 200501 AND 200512 EACH 1

, BETWEEN 200601 AND 200612 EACH 1

, BETWEEN 200701 AND 200712 EACH 1

, BETWEEN 200801 AND 200812 EACH 1

, BETWEEN 200901 AND 200912 EACH 1

, BETWEEN 201001 AND 201012 EACH 1

, BETWEEN 201101 AND 201112 EACH 1

, BETWEEN 201201 AND 201212 EACH 1

);

2 REPLIES

Re: PPI multi partition Issue

Finally I got solution for this. See below.

ALTER TABLE AR_ADJ MODIFY PRIMARY INDEX AR_ADJ_NP

PARTITION BY RANGE_N(Per_Ym BETWEEN 200501 AND 200512 EACH 1,
200601 AND 200612 EACH 1 ,
200701 AND 200712 EACH 1 ,
200801 AND 200812 EACH 1 ,
200901 AND 200912 EACH 1 ,
201001 AND 201012 EACH 1 ,
201101 AND 201112 EACH 1 ,
201201 AND 201212 EACH 1

);

Re: PPI multi partition Issue

Just I want to clarify that the query which I have mentioned here is not a multi partition PPI, its a Multi Range PPI. Multi partition can be done only on Teradata 12. See below the example of Multipartiton PPI.

PARTITION BY RANGE_N(Inv_Ym BETWEEN 200501 AND 200512 EACH 1 , 200601 AND 200612 EACH 1 ,... ), RANGE_N (sys_num between 100 and 165 each 1, between 500 and 501 each 1,), RANGE_N (cyc_num between 1 and 100 each 1)