What is a plan and package in db2?

0 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

how can we find nth max salary from A table

5 Answers   IBM,

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

Are views updatable ?

4 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---