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 is Call attach facility? How does it work?
What is the role of union all and union
What is database alias db2?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Do we need cursor for Count(*)?
What does DSNDB07 database do?
What is a recovery log?
How do you select a row using indexes in db2?
How do I create a view in db2?
How can we read records for specific member in CL? AND rpg?
How to define the a field which accepts value till 99999.99 in db2
What is the difference between using bind () and rebind () methods of naming class?