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
can we view the access paths created by dbrm ? how ? thx
How do you pull up a query which was previously saved in qmf?
What is deadlock in db2?
What is a trigger in the db2 database?
How to find primary key of a table in db2?
What are db2 objects?
Explain about dbrm.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is lock escalation in db2?
Explain about cursor stability?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Which is faster delete or truncate?
What is the physical storage length of timestamp data type?
How to execute stored procedure in db2 command editor?
Explain packages.