I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

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,

---

How can we read records for specific member in CL? AND rpg?

0 Answers  

---

Why do chiropractors use drop table?

0 Answers  

---

What is consistency token in db2?

0 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

What is a db2 package?

0 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What is dbrm? What it contains? When it will be created?

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,

---