What is precompiler in db2?

0 Answers  

---

What are the three types of page locks that can be held?

1 Answers  

---

What is node in db2?

0 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,

---

What does reorg do in db2?

0 Answers  

---

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

How to find schema of a table in db2?

0 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---