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

0 Answers  

---

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is COPY PENDING status?

6 Answers  

---

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

---

What is temporal table in db2?

0 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

What is the difference between static and dynamic SQL?

1 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

what are stage one indexable predicates?

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---