What is performance tuning db2?

0 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

How to design maps

1 Answers   Virtusa,

---

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 DCLGEN ?

2 Answers  

---

What is the difference between cursor and select statement?

0 Answers  

---

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

2 Answers   IBM,

---

What is a correlated sub query?

2 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

How do you select a row using indexes in db2?

0 Answers  

---

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,

---