Hi All,
I want to know the equivalent function for isnull in db2
In oracle we can use isnull in predicated for fetching the null values, but we dont have same function in db2? is anyother way to fetch null values through any db2 function.

udb v8.1 in solaris

if any one know please let me know.
thanks
kumar

ISNULL, I believe is in SQL Server and Sybase ...

NVL is Oracle function

and

COALESCE is the equivalent DB2 function .

To clarify, COALESCE(col1,col2) returns col2 if col1 is null or col1 is col1 is not null ...

If I have misunderstood , then ...

If you want to fetch the rows if a column col1 has null values , then
WHERE COL1 IS NULL

Thanks a lot.