What is the difference between Primary key and
unique index?
Answer Posted / guest
The primary key is used to establish referential integrity
relationship with another table and a Unique index is used
to to enforce uniqueness.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
What is the clustering index in the db2 database?
Mention some fields that are a part of sqlca.
Explain the function of data manager.
How do you select a row using indexes in db2?
What is a db2 schema?
How to check table size in db2 sap?
Differentiate between cs and rr isolation levels? Where do you specify them?
Is db2 a mainframe database?
What is the latest version of ibm db2?
What is scrollable cursor in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How do you eliminate duplicate values in db2?
is it compulsory commitment control in journal?
How can we read records for specific member in CL? AND rpg?