What is the difference between Primary key and
unique index?
Answer Posted / guest1
Using the Primary Key you can establish referential
integrity. Unix index will be created upon the Primary Key
column, and the data will be seperately placed in the Index
space. If you have not created Unix Index, while accessing
the table it leads to SQLCODE = -540
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What action db2 takes when a program aborts in the middle of a transaction?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
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's The Percentage Free Space ?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the function of logging in the db2 database?
How to test SQL -911 error while developing COB-DB2 program
What kind of database is db2?
Name the various locking levels available?
Explain the function of data manager.
What is sqlca?
what is the responsibility of the construction superintendent
Why do we need reorg in db2?
Can you use max on a char column?
What are db2 objects?