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

How do you eliminate duplicate values in db2?

940


What is the function of logging in the db2 database?

903


Mention data types used in db2 ?

906


Mention the location where the output received from explain statement is stored.

892


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

885


What is query_cache_limit?

787


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

880


What is bind and rebind in db2?

921


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2183


What does reorg do in db2?

809


Mention the downsides of page level lock.

955


Define buffer pool.

831


What is difference between alias and synonym in db2?

882


Define data page.

850


What is clone table?

831