what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

Mention data types used in db2 ?

0 Answers  

---

Mention the various locks that are available in db2.

0 Answers  

---

What is the function of buffer manager?

1 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 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  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 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,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

What is concurrency in db2?

1 Answers  

---

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---