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 package in cobol db2?

0 Answers  

---

How do I add a column in db2?

0 Answers  

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

How can deadlocks be resolved?

0 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

What is the maximum length of sqlca?

0 Answers  

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---