Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
- 1 Answers
- 5638 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 the isolation levels possible ?
What is a DBRM, PLAN ?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Discuss about db2 bind?
Can one database have multiple instances?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
how to resolve -811 sqlcode .give clear explaination
What is db2 command?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
Write a query to extract first 5 characters of a name in the column Stud_Name?
when does the SQL statement gets executed when you use cursor in the application programming ?
COBOL 
