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
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
How to check sequence on a table in db2?
What are leaf pages?
Which transaction use a command thread ?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are concurrency issues?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is the default page size of buffer pools?
Who uses db2?