Answer / 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 a db2 table?

0 Answers  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What is precompiler in db2?

0 Answers  

---

List out the three types of page locks that can be held.

0 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,

---

What is the role of data manager in the db2 database?

0 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is a clustering index?

2 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

What is the role of schema in the db2 database?

0 Answers  

---