How do you eliminate duplicate values in db2?

0 Answers  

---

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,

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What is clone table?

0 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---