Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
- 1 Answers
- 5222 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 is a predicate?
How to know the primary key of a table without defining the primary key in the table?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How do you run JCL in cobol program
How to resolve -504 sql code in DB2?
What is a base table?
What is the clustering index in the db2 database?
How do I optimize a query in db2?
How to retrieve rows from a db2 table in embedded sql?
Explain about dbrm.
What is load replace in db2?
What is rebind in db2?
COBOL 
