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,

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

What is the use of dclgen in db2?

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

0 Answers   HeadStrong,

---

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What are the prerogatives?

0 Answers  

---

What is a result table?

1 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

Define predicate?

0 Answers  

---

What is DCLGEN ?

3 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---