How to resolve -803 sql code in DB2?

Answer Posted / lakshmi

This error is thrown when you try to insert a row with
existing primary key i.e.Duplicate. If you want to insert
the row either you should delete the already existing row
and insert the new row or update the same row with the new
values for other fields

Is This Answer Correct ?    22 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between drop table and delete table?

556


How to find the maximum value in a column in the db2 database?

611


What types of tables are there in the db2 database?

556


Explain db2.

620


Why do we need reorg in db2?

564






What is the physical storage length of date data type?

732


What is dclgen in db2?

678


Explain about rct in db2?

640


What is the clustering index in the db2 database?

585


what is utility for parm lib

1884


What's The Error Code For Unique Index Voilation?

653


what is the responsibility of the construction superintendent

1664


Explain the contention situations caused by locks?

592


How do you stop a db2 database in linux?

568


Before you give the explain statement, what are the prerogatives?

581