Answer / s

Buffer manager is responsible for reading the data page
from DASD to Virtual storage.

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

Can you Average the Characters ?

3 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is meant by index cardinality?

2 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---