System: Db2 UDB 7.2 on AIX 4.2
Application: J2EE (WAS 4.X)

While firing one UPDATE statement through a Java application, our developers are getting the following error message. The first character of the SQL statement is automatically truncated.


[IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token "PDATE" was found following " ". Expected
tokens may include: "UPDATE". SQLSTATE=42601

Where as in the query it is already "UPDATE TABLE .... ".

Please suggest.

Thanks,
J

This is a typical typo error message. Try to figure out what the exact SQL script was that is send to DB2. Try to send it to DB2 from within Command Center until it works.