yes null is considered as unique value and hence you cannot enter more than one null value in unique index.

Regards,
I.S

________________________________

From: kavitha [mailto:db2udbdba-ezmlmshield-x98090773.[Email address protected]
Sent: Wed 27/09/2006 14:24
To: LazyDBA Discussion
Subject: Null values for unique index



Hi Gurus,
Can we enter more than one null value if there is a unique index created
on a column. Will null be considered as a unique valu.
Thanks in advance

Thanks and regards,
Kavitha Karunakaran
Tata Consultancy Services Limited
415/21-24, Kumaran Nagar,
Sholinganallur,
Old Mahabalipuram,
Chennai - 600 119,Tamil Nadu
India
Mailto: kavitha.[Email address protected]
Website: http://www.tcs.com <http://www.tcs.com/>
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





***************************************************************************************************************************
This e-mail communication and any attachments may be privileged and confidential to Hexaware and are intended only for the
use of the recipients named above. If you are not the intended recipient, please do not review, disclose, disseminate,
distribute or copy this e-mail and attachments. If you have received this email in error, please delete the same alongwith
all attachments thereto and notify us immediately at [Email address protected] .
***************************************************************************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page