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 cursor stability in db2?
Is db2 a mainframe database?
Define buffer pool.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is package in db2 mainframe?
What is IMAGECOPY ?
How do I add a column to an existing table in db2?
Return code 100 means?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Explain an outer join?
How to handle null values in db2
Define declaration generator (dclgen).