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
- 6336 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 |
Do we need cursor for Count(*)?
What are the full forms of spufi and dclgen and why are they used?
Explain how can you do the explain of a dynamic sql statement?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the difference between TYPE 1 index & TYPE 2 index
What is lock escalation?
Is ibm db2 open source?
How can you do the explain of a dynamic sql statement?
How can you quickly find out the # of rows updated after an update statement?
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.
What is the maximum number of columns in a db2 table?
How to run db2 command in windows?
COBOL 
