Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1018


How does db2 sample database connect?

978


Explain various types of locks in db2?

1096


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1192


How many databases can be created inside an instance in db2 ?

987


What is the difference between cursor and select statement?

1061


What is the purpose of rollback and commit?

1107


What is isolation level in db2?

950


Can you use max on a char column?

1040


How does coalesce work?

968


Is db2 a database?

923


Which isolation level provides maximum concurrency?

1101


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1239


What is null indicator in cobol db2?

1000


On which levels locks can be applied?

1070