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

Is db2 a programming language?

820


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

896


How do I import data from excel to db2?

854


what is a corelated subquerry?

859


What is the physical storage length of date data type?

1020


Differentiate between cs and rr isolation levels? Where do you specify them?

846


How to take backup of table in db2?

832


What is copy pending status in db2?

893


What is universal database?

863


What does sqlcabc has?

822


Define sqlca.

881


What is drop table?

806


What is null indicator in db2?

878


Mention data types used in db2 ?

903


can we view the access paths created by dbrm ? how ? thx

6699