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  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

What is db2 plan table?

0 Answers  

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

What is bind in db2?

0 Answers  

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is rct?

0 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---