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

2 Answers   RBS,

---

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,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

What is read-only cursor?

1 Answers  

---

What is the function of buffer manager?

1 Answers  

---

What is cursor with hold option in db2?

0 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

What is commit in db2?

0 Answers  

---

Mention some fields that are a part of sqlca.

0 Answers  

---

Which isolation level provides highest data integrity?

0 Answers  

---