Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005

    Unanswered: DB2 Insert statement with error SQLCODE: -803, SQLSTATE: 23505

    I am trying to Java PrepareStatement insert into a table db2 table and get this error:
    SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: ITXRTLO0;000000BC18
    However, when I ran the insert statement it works fine.

    Anyone have any ideal what happen here

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    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
    "<index-id>" constrains table "<table-name>" from
    having duplicate rows for those columns.
    In other words, you tried to insert a value that violated a unique constraint.
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2014
    thanks for the list guys. it'll really help me.

Posting Permissions

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