Is there any way in DB2 UDB V8.2 to implement this concept - unique where not null? In other words a column which is unique when it isn't null, but multiple/duplicate nulls need to be allowed. I believe DB2 Mainframe allows it but in UDB the UNIQUE constraint appears to require NOT NULL data.

All I can thing of is to define the column as allowing nulls and to enforce uniqueness thru insert and update triggers. Any other bright ideas from anyone?

Best, Hal

-----Original Message-----
From: Edwards Ed <db2udbdba-ezmlmshield-x5902541.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Mon, 20 Feb 2006 11:28:39 -0500
Subject: DB2 Version 8.2


To All,
I am currently downloading DB2 version 8.2, FP 8 for Windows. In this
version, can you drop a column? Can you rename a column? Thanks.


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]


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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