When can an insert of a new primary key value threaten
referential integrity?
- 2 Answers
- 6375 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / pawan
when the value violates the rule of primary key....new
insert value must be unique.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What do you mean by storage group (stogroup)?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What are catalog tables in db2?
Can one database have multiple instances?
What types of tables are there in the db2 database?
What are types of indexes?
What is drop table?
What is the function of logging in the db2 database?
What are the two types of logging in the db2 database? Explain them.
What is the clustering index in the db2 database?
What is host variable in db2 cobol?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
When the like statement is used?
What is the max length of sqlca?
Define check constraint.
