Never. Such processing could produce duplicate values violating entity in

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

Question Posted / vinod babu bachina

1 Answers
6115 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are db2 objects?

1045

What is dclgen in db2?

1148

What is ibm db2 connect?

999

What does db2 mean?

1017

What is the usage of open cursor command?

1100

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is load replace in db2?

992

Can one database have multiple instances?

1054

What is plan in cobol db2?

1138

What happens in bind step in a db2 program?

970

Is ibm db2 free?

1009

What is ibm db2 used for?

1079

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1437

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101