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


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

812


Comment whether the cursor is closed during commit or not.

874


What are the benefits of using the db2 database?

901


What is role in db2?

815


How to find the maximum value in a column in the db2 database?

831


What db2 400?

911


What is bind and rebind in db2?

891


What is with ur in db2?

1038


What is query_cache_limit?

766


What is isolation level in db2?

771


What does db2 blu stand for?

901


What do you mean by between and in? Is between inclusive of specified range values?

882


When do you specify the isolation level?

801


How to view db2 table structure?

805


Define buffer pool.

809