Interested to Buy Any Domain ? << Click Here >> for more details...
When can an insert of a new primary key value threaten
referential integrity?
- 2 Answers
- 7400 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 |
What is copy book?
What is a host variable?
how can i pull up a query which was previously stored in qmf
How to design maps
How do you filter out the rows retrieved from a Db2 table ?
Give a brief description of db2 isolation levels?
What are concurrency issues?
Comment whether the cursor is closed during commit or not.
How do I delete a column in db2?
Is ibm db2 open source?
how to u check the query is executing or not ?where will u check for sqlcode ?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
COBOL 
