Answer / ravi

Simple joins gives only matching/common values from two or
more tables

If you have mentioned only Outer joins then it is same as
simple join gives the matching values from two or more
tables but outer joins are of two types--- right outer join
and left outer join

for right outer join--- it will give non matching rows also
from right table in addition to matching rows
for left outer join-- it will give non matching rows also
from left table in addtion to matching rows

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

How can you count the number of rows from a table tab?

0 Answers  

---

What is dbrm? When it will be created?

0 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What is the default page size of buffer pools?

0 Answers  

---

What are db2 objects?

0 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

How do I start db2 in windows?

0 Answers  

---