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 is rct?
What is difference between rollback and commit?
What is a storage group (stogroup)?
What is the maximum size of varchar data type in db2?
How can you classify the locks in db2?
What is the information associated with sysibm.syslinks table?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the use of db2 optimizer?
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?
What is the use of db2?
How do you select a row using indexes in db2?
How to execute stored procedures?
What is the difference between cursor stability and repeatable read isolation levels?
What is a db2 table?
What is bufferpool in db2?