No, you cannot enter more than one null value in a unique index. The
null value will be considered as a unique value.
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: kavitha
[mailto:db2udbdba-ezmlmshield-x98090773.[Email address protected]
Sent: Wednesday, September 27, 2006 4:54 AM
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
=====-----=====-----=====
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
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page