Quantified predicates
A quantified predicate compares a value with a set of values produced by
a subselect.
expression comparison-operator SOME | ANY | ALL ( subselect )
The expression must not evaluate to a reference type.
When SOME or ANY is specified the result of the predicate is as follows:
- TRUE if the comparison is true for at least one value returned by the
subselect.
- FALSE if the subselect is empty or if the comparison is false for every
value returned by the subselect.
- UNKNOWN if the comparison is not true for all of the values returned by
the subselect and at least one of the comparisons is unknown because of a
null value.
When ALL is specified the result of the predicate is as follows:
- TRUE if the subselect returns empty or if the comparison is true to every
value returned by the subselect.
- FALSE if the comparison is false for at least one value returned by the
subselect.
- UNKNOWN if the comparison is not false for all values returned by the
subselect and at least one comparison is unknown because of a null value.

EJB query language
WHERE clause

Using EJB query
Searchable topic ID:
cque_quanpred
Last updated: Jun 21, 2007 9:56:50 PM CDT
WebSphere Application Server for z/OS, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.zseries.doc/info/zseries/ae/cque_quanpred.html