Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

Are views updateable?

0 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What is the function of buffer manager?

1 Answers  

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

What is package versioning? Please give an example.

1 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---