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
What are types of indexes?
What is SPUFI?
Explain about open switch business continuity software?
Can you use max on a char column?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
How to get Top 10 Salaries from a Table
Outputs of explain are with matchcols = 0. What does this signify?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token