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 / mani

Unique index can have null values and no null value is equal
to another null value.

i don't know if it raises an error or not when you insert a
null value.
Null value acceptance in the column is again based on the
definition given for the column whether it can accept null
values or not.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the full forms of spufi and dclgen and why are they used?

850


What is a trigger in the db2 database?

810


What is the reason behind not using select * in embedded sql programs?

852


What is copy pending and check pending in db2?

756


What is the difference between cursor stability and repeatable read isolation levels?

917


What are types of indexes?

781


How to create backup table in db2?

854


What is dclgen (declaration generator)?

821


What are the various data types available in db2?

820


What is blu acceleration in db2?

830


What is null in db2?

760


What is syscat in db2?

781


List out the data types available.

921


i want to maintain uniqueness on pdf without make lf??????????

1908


How to check last update on table in db2?

818