What do you do to keep the cursor from closing after a commit?

1 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

What is cursor with hold option in db2?

0 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

---

how to resolve -811

2 Answers   IBM,

---

How to see the structure of db2 table??

4 Answers   IBM,

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

What is a lock?

1 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is the meaning concurrency in the db2 database?

0 Answers  

---