Highlight all the advantages that are attached to a package.

0 Answers  

---

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,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---

What are the uses of db2 optimizer?

0 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

What is difference between isnull and coalesce?

0 Answers  

---

What is a page in db2?

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

What is an intent lock?

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

---

is there any restrictions for unions ?

4 Answers   Patni,

---

How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---