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

Which is faster delete or truncate?

868


Is ibm db2 free?

754


Define check constraint.

832


What is the difference between bind and rebind in db2?

1172


Give a brief description of db2 isolation levels?

779


How can you quickly find out the # of rows updated after an update statement?

788


Why select is not preferred in embedded sql programs?

924


What are bind parameters in db2?

788


What is db2 stogroup?

881


How do I start db2 in windows?

786


Mention the downsides of page level lock.

909


What is the use of commit in db2?

809


What does reorg do in db2?

771


How to create db2 table in mainframe?

847


What is the maximum size of a char data type in db2?

769