Can you search give an array in the WHERE clause of a db2 query?

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,

---

What is reorg in DB2

3 Answers   Virtusa,

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

How to see the structure of db2 table??

4 Answers   IBM,

---

What is query_cache_limit?

0 Answers  

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

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

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---