Interested to Buy Any Domain ? << Click Here >> for more details...
What is the self-referencing constraint?
- 2 Answers
- 6241 Views
- I also Faced
- E-Mail Answers
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 |
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
I use CS and update a page. Will the lock be released after I am done with that page?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is precompiler in db2?
How do I delete a column in db2?
What is cursor with hold option in db2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is clone table?
What is an alias and how does it differ from a synonym?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
How many clustering indexes can be defined for a table?
What is a lock?
COBOL 
