Can a unique index have more than one null value? If not, what error code is g

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?

Question Posted / shefali799

3 Answers
6526 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can a unique index have more than one null value? If not, what error code is given if an attempt i..

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

Can a unique index have more than one null value? If not, what error code is given if an attempt i..

Answer / sri

Null value will allow only one null (That is maximum) as
per DB2 stds. If we try to insert more we get error -305.

Is This Answer Correct ?

2 Yes

5 No

Can a unique index have more than one null value? If not, what error code is given if an attempt i..

Answer / ratheesh

No. A SQLCODE of -803 (duplicate insert) will be returned.

Is This Answer Correct ?

0 Yes

6 No

Post New Answer