What is the self-referencing constraint?
Answers were Sorted based on User's Feedback
Answer / s
Self-referencing constraint makes the table both the parent
and dependent table in the same referential constraint. The
foreign key to the table is defined after the table is
created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mehdee
- To me it is when we create DB2 table and we use options
like, for example:
CONSTRAINT BONUS CHECK(BONUS <= SALARY)
OR
RESTRICT ON DROP
| Is This Answer Correct ? | 1 Yes | 0 No |
What are db2 tables?
what is utility for parm lib
What is the difference between static and dynamic SQL?
How can you do the explain of a dynamic sql statement?
How many buffer pools are there in DB2?
what is the role of the cursor in db2?
What is PRIME TABLE and what are the uses of it
Mention the downsides of page level lock.
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What is the function of logging in the db2 database?
What is pagespace?
What is meant by index cardinality?