Interested to Buy Any Domain ? << Click Here >> for more details...
Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
- 1 Answers
- 6105 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 are common abends
What is the purpose of the DSNC transaction ?
What is referential integrity?
what needs to be done if a table is in copy pending / check pending status?
What's the maximum number of volumes that can be added to a STOGROUP?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What information is used as input to the bind process?
What is isolation level in db2?
where can we use index and subscript ? with example ?
what is the soft code for deadlock ?
What is a db2 collection?
COBOL 
