Nevermind, I got it. Evidently,
DB2 does not like semicolons at the end of statements.
-Jason
"Jason Kretzer/STAR
BASE Consulting Inc." <JKretzer@starbaseinc.com>
04/01/2004 09:53 AM
Please respond to
ajug-members@ajug.org
To
ajug-members@ajug.org
cc
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.