Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 6256 Views
- IBM, I also Faced
- E-Mail Answers
Answer / santosh kumar d
If the col2 field having any null value then that value to
be updated.
If col2 doesn't have any null value then record remains same
nothing will be updated.
| Is This Answer Correct ? | 4 Yes | 6 No |
How would the varchar column remarks defined?
WHAT IS MEANT BY COMMIT COMMAND?
What does reorg do in db2?
How to access db2 tables in mainframe?
what needs to be done if a table is in copy pending / check pending status?
Which isolation level provides highest data integrity?
How do I delete a table in db2?
how do u update the faltfile into db2 table ?
what is REORG? what is the use?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
My SQL is not performing well. Describe how will you fine tune it?
What is a DBRM, PLAN ?
COBOL 
