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 |
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
What are the functions of Bind?
What is the maximum length of sqlca?
What does CURRENTDATA option in bind indicate
What is the information associated with sysibm.syslinks table?
What are the various isolation levels possible?
What is bind plan?
What is meant by AUTO COMMIT?
What is EXPLAIN?
What is a host variable?
Which isolation level provides highest data integrity?
What are host variables in db2?