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

What is runstats and reorg in db2?

1030


Define buffer pool.

809


Name the lockable units in DB2?

909


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2684


What is check constraint in db2?

827


What are the different types of base tables?

777


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

851


can we view the access paths created by dbrm ? how ? thx

6662


Comment whether the cursor is closed during commit or not.

874


What is multi row fetch in db2?

784


How to execute stored procedure in db2 command editor?

762


How do I connect my db2 database to ibm?

801


What are concurrency issues?

821


What is ibm db2 connect?

756


What is host variable?

828