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
6119 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

What is node in db2?

986

What is table space in db2?

960

What are the 2 sqlcodes that are returned?

1129

What is a storage group (stogroup)?

1189

What is collection in db2 bind?

961

What is declare cursor?

1043

How do you eliminate duplicate values in db2?

1108

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1220

What is the physical storage length of time data type?

1064

What is package in cobol db2?

1076

What is the role of the data page in the db2 database?

972

What db2 400?

1103

Is db2 a programming language?

983

List out the buffer pools in db2

1020