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 meant by union and union all?

0 Answers  

---

wht displays the number of times a query modified ?

2 Answers   TCS,

---

How to check sequence on a table in db2?

0 Answers  

---

What happens to a cursor after a commit?

3 Answers  

---

What is a cursor in programming?

0 Answers  

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

What is bind and rebind in db2?

0 Answers  

---

What is database reorganization?

0 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---