Suppose we have a query for update update table1 set col1 = 'val1'

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 / neilsh

1 Answers
6225 Views
IBM, I also Faced
E-Mail Answers

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select..

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

Post New Answer

More DB2 Interview Questions

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers TCS,

what is the role of the cursor in db2?

0 Answers

How can you display the current date & current time ?

1 Answers Cap Gemini,

How and when does the db2 enforces the unique key?

0 Answers

What is SPUFI?

4 Answers

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers IBM,

What is the difference between CS and RR isolation levels?

1 Answers

What is an asychronous write?

1 Answers

What is dynamic SQL?

1 Answers ADP,

can any body explain about plan and pakage in detail....

2 Answers HSBC, IBM,

What's The Error Code For Unique Index Voilation?

0 Answers IBM,

For more DB2 Interview Questions Click Here