Answer / s

Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.

What is meant by union and union all?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

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,

---

what's the error code for Unique Index Violation?

2 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

What are the three types of page locks that can be held?

1 Answers  

---

How to check last update on table in db2?

0 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

What is a correlated sub query?

2 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---