How are write I/Os from the buffer pool executed?

1 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

What is a view? Why use it?

2 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

---

How to execute stored procedures?

0 Answers  

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

How to handle null values in db2

4 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

What will the COMMIT accomplish?

5 Answers  

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---