How to resolve -803 sql code in DB2?

Answer Posted / venkata sastry

The SQL - 803 error occurs on the violation of a UNIQUE
constraint. Update the record if it already exists rather
inserting new one.

Is This Answer Correct ?    15 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is plan in cobol db2?

595


Why db2 is called db2?

595


Why do chiropractors use drop table?

662


What is syscat in db2?

580


How can the duplicate values be eliminated from db2 select?

631






What is check constraint in db2?

608


What does db2 mean?

589


How can you classify the locks in db2?

636


Discuss about db2 bind?

673


What is the physical storage length of time data type?

673


What do you mean by between and in? Is between inclusive of specified range values?

668


What is the difference between bind and rebind in db2?

858


How to rename a table in DB2 ?

641


Mention the different locking levels that are available in db2.

645


How do we specify index to include or not during bind process.

1674