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 copy pending status in db2?
Is db2 a database?
What are the different types of base tables?
What is db2 purescale?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Is ibm db2 free?
Is db2 a mainframe database?
What is innodb buffer pool?
What is host variable?
How to check table size in db2 sap?
What is deadlock in db2?
B37 abend during spufi?
What is the syntax for creating a table in the db2 database?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can we retrieve the total number of records in RPG & CLLE?