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
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Which is faster delete or truncate?
What are packages in db2?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is dbrm? When it will be created?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What are the three DB2 date and time data types and their associated functions?
what is the input to PLAN? what is the input to DBRM?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
Explain about dbrm.
What is a correlated sub query?
how to fetch first 100 rows in db2