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

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.

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....

How can we read records for specific member in CL? AND rpg?

0 Answers  

---

What is an asychronous write?

1 Answers  

---

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

0 Answers  

---

What is pagespace?

1 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

What are foreign keys?

1 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---