db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: ERROR 42X01: Syntax error: Encountered "(" at line 1, column 39.
Date Sun, 19 Jul 2009 15:02:34 GMT
> this ddl gets executed only if we remove datatype lengths/sizes.

> CREATE TABLE employee  ( empId INTEGER(10) NOT NULL,  lastName VARCHAR 
> (30),  firstName VARCHAR (30),  salary DOUBLE PRECISION (19, 2));

That is correct; not all data types have a corresponding length in their
syntax. You can find the Derby data type syntax documented here:
http://db.apache.org/derby/docs/10.5/ref/crefsqlj31068.html#crefsqlj31068

thanks,

bryan


Mime
View raw message