For unmatched rows returned from an outer join, the column
values in the other table are set to null e.g If A OUTER
JOIN B returns some unmatched rows from A, the
corresponding column values in B will be set to null. What
can be done so that a null value is not displayed for these
columns?
Answers were Sorted based on User's Feedback
Define predicate?
List out the data types available.
When the like statement is used?
Is ibm db2 open source?
how to copy the host variables from ps file into cobol program other than include statement
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is an instance database?
Give a brief description of db2 isolation levels?
Is db2 a database?
What is RUNSTATS?
What are the disadvantages of PAGE level lock?
how to get duplicate records from tables?write qurey for this?