When can an insert of a new primary key value threaten
referential integrity?
Answer Posted / naveen
When this primary key is also a foreign key to another
table and that table is not having the value you are trying
to insert.
RI constraint doesn't allow you to insert a primary key
value into your table if its not present in table your are
having constraint with
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the use of value function?
What is db2 look?
Can there be more than one cursor open for any program?
Why cursor is used in db2?
What are the 2 sqlcodes that are returned?
What is cursor stability in db2?
What is check constraint. Explain with example.
What is a storage group (stogroup)?
How to compare data between two tables in db2?
How to create db2 table in mainframe?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How to find the maximum value in a column in the db2 database?
What is the difference between using bind () and rebind () methods of naming class?
What is the syntax for FETCH in DB2 ?
What is a db2 collection?