I have a table t1(c1 int,c2 char(10),c3 char(10))
I have an unique index on (c1) with include (c2,c3)
when I try to access this table using php and if c2 or c3 contains null values it returns me the resultset but with empty values

Hi,

I don't know what the problem is (I don't know the PHP), but I think this is normal working of DB2.

Could you please send the SQL and sample data? Please also specify the operating system and db2 version and fixes. You can also read thread Must Read before posting for more tips.

Grofaty