Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

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 get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

What is the latest version of ibm db2?

0 Answers  

---

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

What is dbrm?

0 Answers  

---

Are views updateable?

0 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What does a deadlock mean in DB2?

0 Answers  

---

Explain about dbrm.

0 Answers  

---