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 package in db2 mainframe?

735


How do I add a column to an existing table in db2?

788


What is bind package and plan in db2?

806


How to execute stored procedures?

855


Define db2.

868


Which command is used to connect to a database in DB2 ? Give the Syntax.

841


What is the purpose of using commit?

835


What is meant by union and union all?

785


How can the duplicate values be eliminated from db2 select?

867


Can there be more than one cursor open for any program?

915


What is the syntax for FETCH in DB2 ?

926


Explain about open switch business continuity software?

835


What is commit in db2?

811


How to find schema of a table in db2?

761


Explain db2.

821