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
What are the full forms of spufi and dclgen and why are they used?
What is a trigger in the db2 database?
What is the reason behind not using select * in embedded sql programs?
What is copy pending and check pending in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What are types of indexes?
How to create backup table in db2?
What is dclgen (declaration generator)?
What are the various data types available in db2?
What is blu acceleration in db2?
What is null in db2?
What is syscat in db2?
List out the data types available.
i want to maintain uniqueness on pdf without make lf??????????
How to check last update on table in db2?