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 of Use | Feedback

Last updatedLast updated: Sep 19, 2011 5:16:49 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=matt&product=was-base-iseries&topic=cque_null
File name: cque_null.html