Results 1 to 4 of 4

Thread: Sql0803n

  1. #1
    Join Date
    Aug 2012
    Posts
    14

    Unanswered: Sql0803n

    Hi - All,

    Please help me to solve this error. Let me know if it is an db2 error or application error.

    SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "XXXXXXX" from having duplicate values for the index key. SQLSTATE=23505

    Thanks.

  2. #2
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    -803 sqlcode means exactly what you quoted:
    you violated index requirements - you attempted to insert a duplicate.

    db2 error - yes - in a sense that db2 is telling you that you have made an error
    db2 bug? - no - only if you are thickheaded and have not bothered to debug your application code.

    you are trying to insert a duplicate - simple as that.
    Dick Brenholtz, Ami in Deutschland

  3. #3
    Join Date
    Jan 2012
    Posts
    20
    Can you post the CREATE TABLE statement and also the SQL statement you were trying to execute? DB2 version, OS, fixpacks etc.

  4. #4
    Join Date
    Aug 2012
    Posts
    14
    Thanks for your response.

    There is a problem with application code.

Posting Permissions

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