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 is rct?

1012


What is difference between rollback and commit?

913


What is a storage group (stogroup)?

1011


What is the maximum size of varchar data type in db2?

890


How can you classify the locks in db2?

862


What is the information associated with sysibm.syslinks table?

901


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

818


What is the use of db2 optimizer?

849


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1865


What is the use of db2?

822


How do you select a row using indexes in db2?

874


How to execute stored procedures?

879


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

949


What is a db2 table?

793


What is bufferpool in db2?

826