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  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What is the function of the Data Manager?

2 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

What is the use of db2 optimizer?

0 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

What is a root page?

1 Answers  

---

What language is db2 written in?

0 Answers  

---