PPI

Database

PPI

I'm getting error for the below query, can anyone suggest a better idea to solve the problem.

3706 - Syntax error: expected something between ')' and ')'.

create table tablename (
...................
....................
) PRIMARY INDEX clm_nupi_key (pty_key) PARTITION BY RANGE_N(fill_dt BETWEEN '2001-01-01'(DATE) AND '2009-12-31'(DATE) EACH INTERVAL '1' MONTH , NO RANGE OR UNKNOWN)) BETWEEN 1 AND 00109);
1 REPLY

Re: PPI

Try this!!!!!

CREATE TABLE TABLE_NAME(
PTY_KEY INTEGER
,FILL_DT DATE FORMAT 'YYYY-MM-DD'

) PRIMARY INDEX CLM_NUPI_KEY (PTY_KEY)

PARTITION BY RANGE_N
(FILL_DT BETWEEN '2001-01-01'(DATE)
AND '2009-12-31'(DATE) EACH INTERVAL '1' MONTH , NO RANGE
OR UNKNOWN)