what is cursor stability?

2 Answers   IBM,

---

Is db2 a mainframe database?

0 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---

define clustering index.

0 Answers  

---

---

What type of database is db2?

0 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---