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
- 6219 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do I optimize a query in db2?
What kind of database is db2?
Is db2 a mainframe?
How and when does the db2 enforces the unique key?
What is reorg and runstats in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is explain plan in db2?
What is database reorganization?
What is the use of commit in db2?
List out the data types available.
What is host variable?
What is the use of runstats in db2?
Explain dclgen.
How do I add a column to an existing table in db2?
