What is JOIN and different types of JOIN.
- 2 Answers
- 11413 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nidhi sharma
joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join
| Is This Answer Correct ? | 26 Yes | 1 No |
Answer / vamsikrishnamraju
Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join
| Is This Answer Correct ? | 7 Yes | 4 No |
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is a lock?
Why cursor is used in db2?
What is ibm db2 client?
What is database manager in db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a db2 package?
Name some fields from SQLCA.
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is table space in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
COBOL 
