Interested to Buy Any Domain ? << Click Here >> for more details...
What is the cascade rule and how does it relate to
deletions made with a subselect?
- 1 Answers
- 5653 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
When is the authorization check on DB2 objects done - at BIND time or run time?
Can any one tell me about Restart logic in DB2.
What happens in bind step in a db2 program?
What is sqlca?
How to find the number of rows in db2 tables?
Describe the elements of the SELECT query syntax?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How do I import data from excel to db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What are types of indexes?
What are union and union all?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
COBOL 
