What does an outer join do?
Answer / guest
Includes unmatched rows from both tables. If any column of
the result table does not have a value, that column has the
null value in the result table.
| Is This Answer Correct ? | 12 Yes | 1 No |
What is DB2 (IBM Database 2)?
What is the size of a data page?
What is consistency token in db2?
Explain various types of locks in db2?
what is difference between Static call and Dynamic call? How does it function?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the physical storage length of date data type?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
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?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!