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 |
How does DB2 determine what lock-size to use?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is the database descriptor?
What does db2 blu stand for?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Can any one tell me about Restart logic in DB2.
What is package in db2 mainframe?
What should be specified along with a cursor in order to continue updating process after commit?
where will u check for sqlcode ?