Hi ,

I have a requirement where I need to create a unique constraint which accepts null value. But in DB2, a unique constraint column should be defined with NOT NULL.
How can i do this. ?

Create a regular index on the column. In your program that inserts the row, if the value is not null, do a select to see if that value already exists. If the value already exists in the table and the value is not null, then process the data as a user error.