Interested to Buy Any Domain ? << Click Here >> for more details...
What does an outer join do?
- 1 Answers
- 7683 Views
- CTS, I also Faced
- E-Mail Answers
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 a Cartesian product?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
Is db2 a mainframe database?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What are the various locks available?
What is check constraint. Explain with example.
Describe what a storage group(STOGROUP) is?
If I have a view which is a join of two or more tables, can this view be updateable?
When is the skeleton cursor table created?
How to define the data items to receive the fetch items for the SQL?
COBOL 
