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 |
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
List out the data types available.
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What do you need to do before you do EXPLAIN ?
What is meant by index cardinality?
What is role in db2?
What is the meaning of -805 SQL return code?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What are the functions in DB2?
What is database reorganization?
Explain dclgen.
How Plan is created while executing the query using SPUFI?