Can a unique index have more than one null value? If not,
what error code is given if an attempt is made to insert
more than one null value?
Answer Posted / ratheesh
No. A SQLCODE of -803 (duplicate insert) will be returned.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How do you eliminate duplicate values in db2?
What is the function of logging in the db2 database?
Mention data types used in db2 ?
Mention the location where the output received from explain statement is stored.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is query_cache_limit?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is bind and rebind in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What does reorg do in db2?
Mention the downsides of page level lock.
Define buffer pool.
What is difference between alias and synonym in db2?
Define data page.
What is clone table?