By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,502 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

IS NOT DISTINCT FROM ?

P: n/a
Ian

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,
Sep 21 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/
Sep 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.