Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest


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

How to find schema of a table in db2?

0 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

What is dynamic SQL?

1 Answers   ADP,

What is the difference between plan and package in db2?

0 Answers  

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

What is the use of commit in db2?

0 Answers  

What are the contents of a DCLGEN?

4 Answers   MetLife,

What is bufferpool in db2?

0 Answers  

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

What is the difference between group by and order by?

2 Answers   IBM, TCS,

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

How do you define a correlated name?

1 Answers  

For more DB2 Interview Questions Click Here
Categories