IN predicate

The IN predicate compares a value to a set of values and can have one of two forms:

expression [NOT] IN  ( subselect )
expression [NOT] IN  ( value1, value2,  .... ) 

ValueN can either be a literal value or an input parameter. The expression can not evaluate to a reference type.

Example: IN predicate

e.salary IN ( 10000, 15000 )

is equivalent to

( e.salary = 10000  OR  e.salary = 15000 )

e.salary IN ( select  e1.salary from EmpBean e1 where e1.dept.deptno = 10)

is equivalent to

e.salary = ANY   ( select  e1.salary from EmpBean e1 where e1.dept.deptno = 10) 

e.salary NOT IN ( select  e1.salary from EmpBean e1 where e1.dept.deptno = 10)

is equivalent to

e.salary <> ALL    ( select  e1.salary from EmpBean e1 where e1.dept.deptno = 10)


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



Searchable topic ID:   cque_in
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_in.html

Library | Support | Terms of Use | Feedback