Answer / rockys

Can be used ONLY with cursor

Answer / sunil

there should be no duplicates in the tables.

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

What is a page?

2 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,

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

Compare a subselect to a join?

1 Answers  

---

Can we insert update delete in view?

0 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

What is schema in db2?

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

How to view db2 table structure?

0 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

Which isolation level provides maximum concurrency?

0 Answers  

---