If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is REORG? When is it used?

4 Answers  

---

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

---

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,

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What is SPUFI?

4 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

What does the REORG Utility do?

2 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

What is the role of data manager in the db2 database?

0 Answers  

---