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
- 6264 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 |
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
The only place of VSAM KSDS in DB2 is?
is it compulsory commitment control in journal?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What is a view? Why use it?
What is a page in db2?
What is difference between isnull and coalesce?
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....
Explain packages.
What are the bind parameters ibm db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Define declaration generator (dclgen).
COBOL 
