Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

How is deadlock resolved?

0 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

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,

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

What is a clustered index?

1 Answers  

---

How do I change the column size in db2?

0 Answers  

---

Define predicate?

0 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

What is the difference between cursor and select statement?

0 Answers  

---