How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

what is cursor stability?

2 Answers   IBM,

---

---

What is db2 optimizer?

0 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---

What is a page in db2?

0 Answers  

---

What is the self-referencing constraint?

2 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

Update command

1 Answers  

---