What is the database descriptor?

2 Answers  

---

Name the lockable units in DB2?

0 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What is a clustering index?

2 Answers  

---

What is subquery ?

6 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

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

3 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

What is REORG? When is it used?

4 Answers  

---

What is a db2 collection?

0 Answers  

---