NULL predicate

The NULL predicate tests for null values.

Use the syntax:
single-valued-path-expression IS [NOT] NULL

Example: NULL predicate

e.name IS NULL
e.dept.name IS NOT NULL
e.dept IS NOT NULL



Related concepts
EJB query language
WHERE clause
Related tasks
Using EJB query
Concept topic Concept topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Feb 5, 2014 9:49:51 PM CST
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-mp&topic=cque_null
File name: cque_null.html