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 bufferpool in db2?

574


B37 abend during spufi?

978


Can you use max on a char column?

634


What is explain plan in db2?

586


What is the default page size of buffer pools?

644






If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1572


How to find schema of a table in db2?

568


What is the use of db2 optimizer?

604


What is db2 connect?

599


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

579


Is the primary key a clustered index?

605


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1589


What db2 400?

673


How do I start db2 in windows?

554


How do you simulate the explain of an embedded sql statement in spufi/qmf?

630