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 do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What is a composite index and how does it differ from a multiple index?
Name some fields from SQLCA.
What types of tables are there in the db2 database?
what is the sqlcode -501
What do the initials DDL and DML stand for and what is their meaning?
How to resolve -917 sql code in DB2?
What are the abend codes occour in ur latest PROJECT in DB2
what is the process of precompiler?
What are the 2 sqlcodes that are returned?
Is schema the same as database?
What are packages in db2?