db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sridhar devatha <devatha.srid...@gmail.com>
Subject ERROR 42X01: Syntax error: Encountered "(" at line 1, column 39.
Date Sun, 19 Jul 2009 10:16:14 GMT

I am getting syntax error while executing the below ddl.

I don't know what is wrong with this. please help. what is suprising is this
ddl gets executed only if we remove datatype lengths/sizes. strange you
CREATE TABLE employee  ( empId INTEGER(10) NOT NULL,  lastName VARCHAR (30),
 firstName VARCHAR (30),  salary DOUBLE PRECISION (19, 2));

I am using Apache Derby Network Server -


Yours Sincerely,

View raw message