How will you delete duplicate records from a table?

7 Answers   Google,

---

what is sql abend code -801,-802?

2 Answers  

---

What is buffer pool?

0 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

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,

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---