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
Hi,

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
know.
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 - 10.5.1.1.

-- 

Yours Sincerely,
Sridhar

Mime
View raw message