Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
- 1 Answers
- 5674 Views
- I also Faced
- E-Mail Answers
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 are the two types of logging in the db2 database? Explain them.
B37 abend during spufi?
How do I copy a table in db2?
What is the role of union all and union
What is reorg and runstats in db2?
What db2 400?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How to test SQL -911 error while developing COB-DB2 program
What do you mean by cursor?
What is the use of db2?
When the like statement is used?
How is deadlock resolved?
What is load replace in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Define declaration generator (dclgen).
