Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?



Under what circumstances will DB2 allow an SQL statement to update more than one primary key value..

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

Post New Answer

More DB2 Interview Questions

What is null indicator in db2?

0 Answers  


What is the difference between bind and rebind in db2?

0 Answers  


How to connect to db2 database from windows command line?

0 Answers  


What is DCLGEN?

2 Answers  


What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,






What is the clustering index in the db2 database?

0 Answers  


Is the primary key a clustered index?

0 Answers  


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


Explain db2.

0 Answers  


How do I import data from excel to db2?

0 Answers  


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,


If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  


Categories