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 the function of logging in the db2 database?

1079

---

How to get the ddl of a table in db2?

1081

---

Can there be more than one cursor open for any program?

1130

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2323

---

Which isolation level provides maximum concurrency?

1101

---

Define declaration generator (dclgen).

1072

---

Is the primary key a clustered index?

1086

---

What are bind parameters in db2?

989

---

Why do we use cursor?

1056

---

What do you mean by cursor?

950

---

What is db2 purescale?

951

---

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

589

---

What is check constraint. Explain with example.

1051

---

Why do chiropractors use drop table?

1055

---

How to connect to db2 database from windows command line?

1009

---