Answer / harsha

I feel yes, we can fetch the same cursor in the same
program.
Cursor can be closed in three ways.
1 When you explicitely close trhe cursor.
2 Issuing commit systement.
3 After execution of an application program.

In our situation, none of the above mentioned case is
getting true.

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

1 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What is bind package and plan in db2?

0 Answers  

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What are the rules for db2 programming?

0 Answers  

---

What is a page?

2 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---