Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time?
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 |
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
how can i pull up a query which was previously stored in qmf
What is the cascade rule and how does it relate to deletions made with a subselect?
What are the bind parameters ibm db2?
Normalization in DB2 – first normal form, second normal form
wht steps we need will coding cobol and db2 pgm ?
Give the name of some fields form sqlca.
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How to check last update on table in db2?
What is DB2 (IBM Database 2)?
Name some fields from SQLCA.
what is Runstats? Whem will u choose to runatats?