I saw a presentation on SQL that's supported in DB2 UDB v8 for z/OS, and
it mentioned that the following syntax:

A IS NOT DISTINCT FROM B

is equivalent to:

A = B or (A is null AND B is null)



There was some question whether this is present in DB2 LUW, but I can't
find it in the SQL reference for DB2 9 (and it doesn't work in DB2 V8).


Does anyone know?



Thanks,

Ian wrote:
>
> I saw a presentation on SQL that's supported in DB2 UDB v8 for z/OS, and
> it mentioned that the following syntax:
>
> A IS NOT DISTINCT FROM B
>
> is equivalent to:
>
> A = B or (A is null AND B is null)

> There was some question whether this is present in DB2 LUW, but I can't
> find it in the SQL reference for DB2 9 (and it doesn't work in DB2 V8).
DB2 for LUW does not expose the syntax.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/