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

Null value will allow only one null (That is maximum) as
per DB2 stds. If we try to insert more we get error -305.

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you count the number of rows from a table tab?

867


How can you find out the # of rows updated after an update statement?

886


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1859


Can one database have multiple instances?

837


What is phantom read in db2?

861


What is a dbrm in db2?

795


Why do we need reorg in db2?

775


What os does db2 run on?

779


What is meant by union and union all?

816


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

2703


What is db2 instance?

842


What is declare cursor?

860


What is schema in db2?

808


What is the physical storage length of date data type?

1029


What is buffer pool and list some of them?

831