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 / sri
Null value will allow only one null (That is maximum) as
per DB2 stds. If we try to insert more we get error -305.
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
Comment whether the cursor is closed during commit or not.
What are the benefits of using the db2 database?
What is role in db2?
How to find the maximum value in a column in the db2 database?
What db2 400?
What is bind and rebind in db2?
What is with ur in db2?
What is query_cache_limit?
What is isolation level in db2?
What does db2 blu stand for?
What do you mean by between and in? Is between inclusive of specified range values?
When do you specify the isolation level?
How to view db2 table structure?
Define buffer pool.