Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
- 1 Answers
- 5430 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the three types of page locks that can be held?
Define predicate?
How can you split a table in to exactly half?
What is db2?
How do I add a column in db2?
Where is the access path logic created by the DB2 Optimizer stored?
Where besides the DB2 catalog is database object information stored by DB2?
Compare a subselect to a join?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is the difference between CS and RR isolation levels?
What is QUIESCE?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
COBOL 
