What is query_cache_limit?

0 Answers  

---

Update command

1 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

Which catalog tables contain authorization information?

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

What does db2 mean?

0 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

How do I optimize a query in db2?

0 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

what are extents?

5 Answers  

---