If the col2 field having any null value then that value to be updated. If

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?

Question Posted / santosh kumar d

1 Answers
6257 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

Please Help Members By Posting Answers For Below Questions

Can you use max on a char column?

1097

What's The Percentage Free Space ?

1227

How many types of page locks can be held in db2?

1044

How to check sequence on a table in db2?

1065

What db2 400?

1203

What's The Error Code For Unique Index Voilation?

1242

What is check constraint in db2?

1092

How to take backup of table in db2?

1079

What is access path in db2?

989

What is db2?

1186

Which component is responsible for processing sql statements and selecting access paths?

1134

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2183

How to create backup table in db2?

1096

Can we delete records from view?

970

What is null indicator in cobol db2?

1068