Answer / naidu sekhar naidu

SEQUENTIAL FILE: 1)IF DATA IS ENTRY IN SEQUENTIAL ORDER
2)ACCESS IN SEQUENTIAL ORDER
3)MAIN ADVANTAGE REPORT GENERATION
RANDOM FILE: 1)IF DATA ENTRY IN SEQUENTIAL AS WELL AS RANDOM
2) SEARCHING IS MORE FASTER COMPARE TO THE SEQUENTIAL FILE


CORRECT ME IS AM WRONG U R FRIEND

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,

---

What is performance tuning db2?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

What is runstats db2?

0 Answers  

---

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

What is syscat in db2?

0 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is filter factor?

2 Answers  

---

What is the error code -803 ?

3 Answers  

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---