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 will you return the number of records in table?

937

---

How do I import data from excel to db2?

1072

---

What are catalog tables in db2?

1049

---

B37 abend during spufi?

1455

---

Is it possible using max on a char column?

1139

---

What is the maximum length of sqlca?

1529

---

What is database alias db2?

1126

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1736

---

How connect db2 database to datastage?

1242

---

What is the picture clause of null indicator variable?

1138

---

How is deadlock resolved?

1146

---

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

1045

---

What is the default page size of buffer pools?

1122

---

List out the data types available.

1153

---

What kind of database is db2?

1036

---