In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

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,

---

can any one expalin check point with an example?

1 Answers  

---

When do you specify the isolation level?

0 Answers  

---

What is the role of union all and union

0 Answers  

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  

---

What is a cursor and what is its function?

2 Answers  

---