what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

How do I start db2 in windows?

0 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What are types of indexes?

0 Answers  

---

What is an access path?

3 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

What is the purpose of using commit?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---