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

How to find schema of a table in db2?

1009

---

What are types of indexes?

1064

---

What is netezza database?

1019

---

What language is db2 written in?

1040

---

Explain in brief how does db2 determine what lock-size to use?

1035

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

---

How to find the maximum value in a column in the db2 database?

1072

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1060

---

What do you mean by cursor?

988

---

What is clone table?

1036

---

What is the use of reorg in db2?

1079

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1053

---

What is the maximum number of columns in a db2 table?

1278

---

Is ibm db2 free?

1003

---

Discuss about db2 bind?

1089

---