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 |
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Can you search give an array in the WHERE clause of a db2 query?
What are catalog tables in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
what is the Foreign key? explain?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
How can we define a table? How can we apply SEARCH ALL on it ?
What is meant by repeatable read?
What is catalog database in db2?
What is cursor stability?
What is subquery ?