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
- 6333 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
Is schema the same as database?
What is cloudant database?
What is the maximum size of a char data type in db2?
What is universal database?
What is clone table?
What is the reason behind not using select * in embedded sql programs?
B37 abend during spufi?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can deadlocks be resolved?
How to retrieve rows from a db2 table in embedded sql?
How to check sequence on a table in db2?
is it compulsory commitment control in journal?
Which component is used to execute the sql statements?
Explain correlated sub-queries.
How is the value function used?
