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  

---

What will the FREE command do to a plan?

2 Answers  

---

What is a cursor and what is its function?

2 Answers  

---

What is a db2 tablespace?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

Explain in detail about buffer manager and its functionalities?

0 Answers  

---

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,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---