Return-Path: 
 <derby-user-return-11292-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 55747 invoked from network); 19 Jul 2009 10:15:40 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 19 Jul 2009 10:15:40 -0000
Received: (qmail 23961 invoked by uid 500); 19 Jul 2009 10:16:44 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 23883 invoked by uid 500); 19 Jul 2009 10:16:44 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 23875 invoked by uid 99); 19 Jul 2009 10:16:44 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Jul 2009 10:16:44 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of devatha.sridhar@gmail.com
 designates 209.85.218.218 as permitted sender)
Received: from [209.85.218.218] (HELO mail-bw0-f218.google.com)
 (209.85.218.218)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Jul 2009 10:16:34 +0000
Received: by bwz18 with SMTP id 18so1445397bwz.7
        for <derby-user@db.apache.org>; Sun, 19 Jul 2009 03:16:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:date:message-id:subject
         :from:to:content-type;
        bh=jIbsjNPs9ZzBTw5qfXdL4WRnciS/Qx/Yes8C3hoOESc=;
        b=F0YuXVJeQsxNJPAMhruZrbNs9dhGvQEYhAEVORkPIN0lgkHWD00GYdjAXOC0Bp7dpo
         gfPdCNXstj8eVNEZXKYDT40KkGJvyjFr2pNr4BhoHtiK5UsTO96u8DOxNvcCFMQpGNt4
         rsUjdzWtN3EIQiDE7bqv+HZJBLge7POmZzX8A=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=nj6Qy9iukScThVxqvsOSLZ+N/rXLqxC2MGBgx1TFwQhrFM7wLS0wc6cLndYdctSAbY
         6AhTSzOlhmW/U38ZhUO0+Uhc1/SAsDuEUydglBnFs7dQw1M/AkdC7DX24vxt30luuilF
         v/JBytQ5mxAToRSpkrCLNuUelxEuO3voCQ6Qo=
MIME-Version: 1.0
Received: by 10.239.156.144 with SMTP id m16mr245378hbc.133.1247998574290;
	Sun, 19 Jul 2009 03:16:14 -0700 (PDT)
Date: Sun, 19 Jul 2009 15:46:14 +0530
Message-ID: <e55541230907190316m62bb74fcx8624475d92dc15a4@mail.gmail.com>
Subject: ERROR 42X01: Syntax error: Encountered "(" at line 1, column 39.
From: sridhar devatha <devatha.sridhar@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: multipart/alternative; boundary=001485f454acb366ae046f0c4f5b
X-Virus-Checked: Checked by ClamAV on apache.org

--001485f454acb366ae046f0c4f5b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--001485f454acb366ae046f0c4f5b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi,</div>
<div>=A0</div>
<div>I am getting syntax error while executing the below ddl.</div>
<div>=A0</div>
<div>I don&#39;t know what is wrong with this. please help. what is suprisi=
ng is this ddl gets executed only if we remove datatype lengths/sizes. stra=
nge you know. </div>
<div>CREATE TABLE employee=A0 ( empId INTEGER(10) NOT NULL, =A0lastName VAR=
CHAR (30), =A0firstName VARCHAR (30), =A0salary DOUBLE PRECISION (19, 2));<=
/div>
<div>=A0</div>
<div>I am using Apache Derby Network Server - 10.5.1.1.<br clear=3D"all"></=
div>
<div></div><br>-- <br><br>Yours Sincerely,<br>Sridhar<br>

--001485f454acb366ae046f0c4f5b--