How to resolve -803 sql code in DB2?

Answers were Sorted based on User's Feedback



How to resolve -803 sql code in DB2?..

Answer / 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

How to resolve -803 sql code in DB2?..

Answer / 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

How to resolve -803 sql code in DB2?..

Answer / lu

Before to insert, it's better to select(retrieve),test
sqlcode when 100 insert when 00 update whenever send
message and abend...You don't have an heache....

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More DB2 Interview Questions

what is static sql? what is dynamic sql? Give me details

3 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


What is null indicator in db2?

0 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


Is there any advantage to denormalizing DB2 tables?

1 Answers  


What are the Isolation levels possible ?

5 Answers  


Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


What does DSNDB07 database do?

2 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


Highlight all the advantages that are attached to a package.

0 Answers  


What is the syntax for creating a table in the db2 database?

0 Answers  


What is a DB2 plan?

8 Answers  


Categories