For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

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

1 Answers  

---

Is db2 a programming language?

0 Answers  

---

---

Which components manage deadlocks in db2?

0 Answers  

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

What is a buffer pool?

2 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---