Answer Posted / 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 db2 command?

962

---

What is copy pending status in db2?

1067

---

Explain in detail about buffer manager and its functionalities?

992

---

What is database reorganization?

1051

---

What is the difference between drop table and delete table?

1116

---

What is the difference between cursor and select statement?

1051

---

Can we delete records from view?

914

---

What is check constraint in db2?

1011

---

What do you mean by between and in? Is between inclusive of specified range values?

1037

---

What is the use of reorg in db2?

1023

---

Mention the different locking levels that are available in db2.

1067

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2277

---

How many types of page locks can be held in db2?

993

---

How do I add a column to an existing table in db2?

976

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134

---