Answer Posted / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mention the downsides of page level lock.
What is an instance database?
What is netezza database?
Explain the contention situations caused by locks?
what is db2 restart?
What is ibm db2 used for?
Explain about dbrm.
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is package in db2 mainframe?
What is deadlock in db2?
What type of database is db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
On which levels locks can be applied?
How does coalesce work?
What is db2 bind process?
