what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

What is the meaning concurrency in the db2 database?

0 Answers  

---

---

What is db2 bind process?

0 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What is the error code -803 ?

3 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

How is the value function used?

0 Answers  

---

What is role in db2?

0 Answers  

---