Need Suggestion on -803 error code

sambap · New User Joined: 04 Apr 2014 Posts: 5 Location: India

Hi,

I have cobol db2 program. there inserting the values into the table.

For some rows, though row not exist in the table I am getting -803 error(Unique index violation).

Could you please suggest, what could be the reason?

Pandora-Box · Posted: Fri Apr 04, 2014 5:29 pm

How are you inserting values into the table?

Are you reading the file and inserting the data from the file?

sambap · New User Joined: 04 Apr 2014 Posts: 5 Location: India

Yes reading the file and doing some alternations as per the requirement and inserting into the table.

chandan.inst · Posted: Fri Apr 04, 2014 5:32 pm

Hi,

Have you tried to research on -803 to find out the reason?

A simple google would have given you the answer

sambap · New User Joined: 04 Apr 2014 Posts: 5 Location: India

Hi,

After doing all fight..I reached here Chandan.

I tested with the sample data also, row was not present before inserting. But still getting -803

Pandora-Box · Posted: Fri Apr 04, 2014 5:46 pm

Does your file contain unique records?

sambap · New User Joined: 04 Apr 2014 Posts: 5 Location: India

Yes..It is having unique records.

Pandora-Box · Posted: Fri Apr 04, 2014 5:52 pm

dbzTHEdinosauer · Posted: Fri Apr 04, 2014 7:55 pm

you receive a -803 when you attempt to insert a duplicate.

either you have dups in your input, or you have a logic error in your program,
because you are attempting to insert a row which is causing a duplicate index.

if you can not validate your input,
suggest you put in a few DISPLAYs in your program.

display record read.
display row to be inserted.
display db2 return code after insert.