When can an insert of a new primary key value threaten
referential integrity?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pawan
when the value violates the rule of primary key....new
insert value must be unique.
| Is This Answer Correct ? | 1 Yes | 3 No |
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
how to execute qcmdexc in rpgle?plz write code also?
What is table space in db2?
wht is d/f between union and joins ?
When the like statement is used?
What is the difference between primary key & unique index ?
What action db2 takes when a program aborts in the middle of a transaction?
What does a deadlock mean in DB2?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
Normalization in DB2 – first normal form, second normal form
How will you delete duplicate records from a table?
How can you do the explain of a dynamic sql statement?