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

Which command is used to remove all rows from a table?

0 Answers  

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

What are packages in db2?

0 Answers  

---

What is reorg and runstats in db2?

0 Answers  

---

Is ibm db2 free?

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

What is dpf in db2?

0 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---