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
Can we update view in db2?
What do you mean by commit and rollback?
What is buffer pool?
What is a system catalog table in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Define predicate?
What is the difference between plan and package in db2?
What does db2 mean?
Define declaration generator (dclgen).
define clustering index.
How do I copy a table in db2?
What is release/acquire in bind?
When do you specify the isolation level?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?