Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
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 auditing?
What is -904 sql code? How to resolve it?
What are the functions of Bind?
What are iseries servers?
What does the sqlcode of -818 pertain to?
What is the function of logging in the db2 database?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What do you mean by between and in? Is between inclusive of specified range values?
How do I delete a table in db2?
What is read-only cursor?
What is package in db2 mainframe?
What is a cursor and what is its function?