Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338

    Unanswered: Db2 Update command

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    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.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •