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:

When ALL is specified the result of the predicate is as follows:


Related concepts
EJB query language
WHERE clause
Related tasks
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

Library | Support | Terms of Use | Feedback