suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

What is a LIKE table and how is it created?

2 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

What is cursor with hold option in db2?

0 Answers  

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---