Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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


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

List down the types of triggers in the db2 database?

0 Answers  

How to find primary key of a table in db2?

0 Answers  

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

How to take backup of table in db2?

0 Answers  

What is a DB2 catalog?

2 Answers  

What are the various locks available?

5 Answers   CTS,

How to update more then one record using update?

5 Answers   IBM,

What is -904 sql code? How to resolve it?

3 Answers  

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

how can you access index

4 Answers   IBM, Tech Mahindra,

What is buffer pool in the db2 database?

0 Answers  

For more DB2 Interview Questions Click Here
Categories