by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---

What is a db2 cursor?

0 Answers  

---

Can we delete records from view?

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

what types of copies can be made with the COPY Utility ?

1 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

Can there be more than one cursor open for any program?

0 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

Who uses db2?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---