468,257 Members | 1,441 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

CREATE PARTITIONED TABLE - SQL0104N error

Hi,

I am trying to create a partitoned table using the following:-

CREATE TABLE ORDERS(ID INT, SHIPDATE DATE)
PARTITION BY RANGE(SHIPDATE)
(
STARTING '1/1/2006' ENDING '12/31/2006'
EVERY 3 MONTHS
);

I receive the following error:-

CREATE TABLE ORDERS(ID INT, SHIPDATE DATE) PARTITION BY RANGE(SHIPDATE) (STARTING '1/1/2006' ENDING '12/31/2006' EVERY 3 MONTHS)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "PARTITION BY RANGE" was found following "INT,
SHIPDATE DATE)". Expected tokens may include: "<partitioning_key>".
SQLSTATE=42601

SQL0104N An unexpected token "PARTITION BY RANGE" was found following "INT, SHIPDATE DATE)". Expected tokens may include: "<partitioning_key> ".

Can anyone help
Aug 1 '07 #1
0 1525

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by shsandeep | last post: by
1 post views Thread by Justin | last post: by
reply views Thread by Damir | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.