I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

Which components manage deadlocks in db2?

0 Answers  

---

What is nvl in db2?

0 Answers  

---

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

Define sqlca.

0 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

---

What happens to the PLAN if index used by it is dropped?

1 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---