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
How do I delete a table in db2?
What are catalog tables in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the role of the data page in the db2 database?
What are concurrency issues?
What is the use of dclgen in db2?
How to find primary key of a table in db2?
Discuss about db2 bind?
List some fields from sqlca?
How do I add a column in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are the various isolation levels possible?
Mention some fields that are a part of sqlca.
What is the max length of sqlca?
What are the different types of base tables?