Answer / Manish Arora

Yes, you can update a view in DB2 as long as the view is based on a table that allows the specific type of update operation (INSERT, UPDATE, or DELETE).

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is cursor?

2 Answers  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is filter factor?

2 Answers  

---

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

2 Answers   IBM,

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

Which catalog table stores referential constraints?

1 Answers  

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

What is commit in db2?

1 Answers  

---

What are host variables in db2?

1 Answers  

---

What is the function of buffer manager?

1 Answers  

---