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

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

Answer Posted / ratheesh

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is dbrm? When it will be created?

956

What is db2 look?

970

What is the purpose of using commit?

1039

What is db2 bind?

1015

Explain how can you do the explain of a dynamic sql statement?

1062

What are concurrency issues?

1028

Why do we need reorg in db2?

921

What is bind and rebind in db2?

1072

What is image copy in db2?

943

What is the physical storage length of the data types date, time, and timestamp?

1039

How will you return the number of records in table?

879

What does runstats do in db2?

1022

What is a trigger in the db2 database?

1014

Explain about cursor stability?

981

How to connect to db2 database from windows command line?

999