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.

What is a predicate?

1 Answers  

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  

---

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What is correlation names?

1 Answers  

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

How do you eliminate duplicate values in db2?

0 Answers  

---

How is a typical db2 batch pgm executed?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---