Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

What is lock escalation?

2 Answers  

---

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

What is sqlca?

0 Answers  

---

how to resolve -811

2 Answers   IBM,

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

How does a cursor work?

0 Answers  

---

Can we delete records from view?

0 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---