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
Name the various locking levels available?
How to run db2 command in windows?
Which component is used to execute the sql statements?
Is db2 a mainframe database?
What is bind and rebind in db2?
What is sqlca?
what is the responsibility of the construction superintendent
What is innodb buffer pool?
What kind of database is db2?
What does runstats do in db2?
How to rename a table in DB2 ?
How to find the number of rows in db2 tables?
Mention some fields that are a part of sqlca.
What is null in db2?
What is nvl in db2?