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

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

1090

Can one database have multiple instances?

1095

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1138

What parameters are used to control the free space in DB2?

1094

Which command is used to remove all rows from a table?

1175

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

1173

What is a bind card?

1276

Which are the db2 tools to protect integrity of the database?

1166

What is the latest version of ibm db2?

1333

What is a system catalog table in db2?

1240

What is reorg and runstats in db2?

1259

What is the syntax for FETCH in DB2 ?

1264

What is the role of schema in the db2 database?

1357

How can the duplicate values be eliminated from db2 select?

1155

Why do we need reorg in db2?

1040