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 do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---

How do you stop a db2 database in linux?

0 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is a buffer pool?

2 Answers  

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

Which catalog table stores referential constraints?

1 Answers  

---