What is the cascade rule and how does it relate to
deletions made with a subselect?
Answer Posted / s
Cascade deletes the foreign keys when the primary key is
delted.
When using subselect the rows deleted are based on the rows
that qualify for the subselect.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is ibm db2 used for?
What is the meaning concurrency in the db2 database?
Describe major components of db2?
What is the role of union all and union
Mention the different locking levels that are available in db2.
what is the role of the cursor in db2?
What is the use of runstats in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Explain the function of data manager.
What is a cursor in programming?
What is runstats and reorg in db2?
What are the bind parameters ibm db2?
What is scrollable cursor in db2?
How is deadlock resolved?