How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

What are the benefits of using the db2 database?

0 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

List out the data types available.

0 Answers  

---

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

3 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

Compare a subselect to a join?

1 Answers  

---

Are views updateable?

0 Answers  

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---