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
- 5669 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 |
What are the rules for db2 programming?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is image copy?
What is a db2 table?
Why use RUNSTAT Utility?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What are the benefits of using the db2 database?
What is plan in cobol db2?
How to resolve -917 sql code in DB2?
Explain about dbrm.
What is a host variable?
What is a result table?
COBOL 
