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 |
List some fields from sqlca?
How do I delete a table in database?
What is concurrency?
Mention data types used in db2 ?
What is the SQL Communications Area and what are some of its key fields?
Explain what a plan is?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
how can you access index
if i made sme changes in sub pgm wht r the things to be done for this ?
What is read-only cursor?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?