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

Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?

Answer Posted / vinod babu bachina

Never. Such processing could produce duplicate values
violating entity integrity. Primary keys must be updated one
at a time.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by between and in? Is between inclusive of specified range values?

1049


What is a trigger in the db2 database?

1026


What is the use of runstats in db2?

1040


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1043


What is the clustering index in the db2 database?

962


What is the connection string to connect to the DB2 Database ?

1069


Can you tell me how can you find out the # of rows updated after an update statement?

1052


What is runstats and reorg in db2?

1248


What is database manager in db2?

973


What is db2 instance?

1030


Explain the benefits you can get from mainframe connect?

920


What is cloudant database?

1049


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1330


How do I copy a table in db2?

959


What is meant by union and union all?

960