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 the STOSPACE Utility used for?

1 Answers  

---

What is bind in db2?

0 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---

What is a synonym ?

2 Answers  

---

What is the error code -803 ?

3 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

What is db2 bind process?

0 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---