View previous topic :: View next topic
|
Author |
Message |
Furor
New User
Joined: 04 Jun 2009 Posts: 30 Location: Bangalore
|
|
|
|
Code: |
CREATE TABLE DBName.TableName
(AGE DECIMAL(4,0) ,
NAME CHAR(4))
PARTITION BY RANGE (AGE)
(PARTITION 1 STARTING 4 ENDING 10
IN DBName.TSpaceName );
|
Error
Code: |
SQLERROR ON CREATE COMMAND, PREPARE FUNCTION
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD STARTING. TOKEN ENDING WAS EXPECTED
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 2 0 0 -1 106 506 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000002' X'00000000' X'00000000' X'FFFFFFFF' X'000
|
Db2 Version is 10
I have tried various other ways/example on internet. But nothing actually worked. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
why use examples on the f******* internet.
use the internet to access the manual,
which would explain the CREATE TABLE statement
which is found here
and look for partitioning-clause:
in your case, I would suggest downloading the PDF
then you would not waste time on internet suggestions.
examples are at the bottom of the first link.
You should also look at partition by growth,
since you are using db2 10. |
|
Back to top |
|
|
Furor
New User
Joined: 04 Jun 2009 Posts: 30 Location: Bangalore
|
|
|
|
Thanks Dbz ...
Thanks Ashimer for helping me on call .. |
|
Back to top |
|
|
|