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

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

Question Posted / vinod babu bachina

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 is the default page size of buffer pools?

1070

What is catalog database in db2?

1100

Is db2 free?

1036

How do you select a row using indexes in db2?

1073

What is iseries database?

990

What are the bind parameters ibm db2?

989

Explain in detail about buffer manager and its functionalities?

993

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

How to create db2 table in mainframe?

1103

List down the types of triggers in the db2 database?

963

Which component is responsible for db2 startup and shutdown?

980

What is sqlca?

999

What is the role of union all and union

1069

What is cursor stability in db2?

1277

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8994