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 reorg in database?
What is db2 optimizer?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What are data types?
List down the data types in the db2 database.
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is the difference between using bind () and rebind () methods of naming class?
why we go for SPUFI for creating tables or for sql queries?
what is sql abend code -801,-802?
Which isolation level provides maximum concurrency?
Define data page.