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
What do you mean by between and in? Is between inclusive of specified range values?
What is a trigger in the db2 database?
What is the use of runstats in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the clustering index in the db2 database?
What is the connection string to connect to the DB2 Database ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is runstats and reorg in db2?
What is database manager in db2?
What is db2 instance?
Explain the benefits you can get from mainframe connect?
What is cloudant database?
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
How do I copy a table in db2?
What is meant by union and union all?