Answer Posted / ratheesh nellikkal

Hi All,
Cursor is nothing but a pointer to a result set that you
get as a result of executing a query.
So if u wanna some operations using this cursor then u have
to
1. Declare a cursor
2.Open the cursot before the first access
3.Do the operations
4.Close the cursor.

But in case of a normal cursor (not declared with 'with
hold' option) in between the operations if u issued a
commit command then the cursor will be getting closed and
if u wanna access it again then u should open it again.

But incase of a 'With hold' cursor it will maintane the
states if you issed a commit also.
Means it will not get closed by applying frequent commit.

Regards,
Ratheesh Nellikkal

How can you quickly find out the # of rows updated after an update statement?

1084

---

Explain about mirror activator disk mirroring?

1063

---

Can one database have multiple instances?

1097

---

What is host variable?

1111

---

What is explain in db2?

1078

---

What is consistency token in db2?

1194

---

What is the max length of sqlca?

1270

---

What is the advantage in De-normalizing tables in DB2?

1233

---

What are concurrency issues?

1170

---

Define data page.

1128

---

What is check constraint in db2?

1163

---

Discuss about db2 bind?

1155

---

How do I change the column size in db2?

1205

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1315

---

How to take backup of table in db2?

1121

---