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

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

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which component is responsible for db2 startup and shutdown?

624


What is dbrm?

636


What is dbrm? When it will be created?

594


How to find the number of rows in a db2 table?

644


What does runstats do in db2?

607






What is the use of predicate?

580


What is a storage group (stogroup)?

774


What is universal database?

616


What is dbrm library?

576


What happens in bind step in a db2 program?

563


What is runstats db2?

576


What is precompiler in db2?

585


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

604


What are the 2 sqlcodes that are returned?

633


Why do we bind in db2?

629