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

what is the sqlcode -501

13170

---

What is the default page size of buffer pools?

1125

---

What is meant by dclgen?

1116

---

Mention the definition of cobol in varchar field.

1251

---

Is db2 relational database?

984

---

How many databases can be created inside an instance in db2 ?

1042

---

What is db2?

1186

---

What is db2 plan table?

1054

---

What are the various isolation levels possible?

1124

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2396

---

What is scrollable cursor in db2?

1059

---

What is commit in db2?

1062

---

How to create backup table in db2?

1098

---

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?

9224

---

What is buffer pool and list some of them?

1043

---