RE: [ajug-members]: Don't understand why I am getting SQLException

["Alfreda Duffin" <freets@comcast.net>]

Are you sure the numeric fields are defined to the database as varchar or character??? I'm a little rusty, but I would check each value, are you sure that the table name is correct??

-----Original Message-----
From: Jason Kretzer/STAR BASE Consulting Inc. [mailto:JKretzer@starbaseinc.com]
Sent: Thursday, April 01, 2004 9:53 AM
To: ajug-members@ajug.org
Subject: [ajug-members]: Don't understand why I am getting SQLException

Good morning all,

I am trying to do a standard insert into a DB2 database v8.1.  Here is my SQL statement.


INSERT INTO DB2N.CLIENT (SYSTEM,CLIENTNAME,CLIENTDESC,ADDRESS1,ADDRESS2,ADDRESS3,CITY,STATE,ZIP,CONTACT,TELEPHONE,EMAIL,WEBSITE,GROUP) VALUES ('Y','Company','IT','129 Happy Lane','blank','blank','Cincinnati','OH','45246','Jeff W','5131234567','jeffw@company.com','www.company.com','some group');


And here is the exception that I am getting.

com.ibm.db2.jcc.a.SQLException: An unexpected token "" was found following "".  Expected tokens may include:  "c.com','some group')".


All of the schema is correct and all of the values fit in their respective fields, but there is something wrong that I must be missing.

Anyone have any other ideas?


Thanks,

-Jason