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

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is the physical storage length of time data type?

0 Answers  

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

Explain an outer join?

1 Answers  

---

What is dbrm? When it will be created?

0 Answers  

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  

---

What is the use of with ur in db2?

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What is a subselect? Is it different from a nested select?

1 Answers  

---