EJB query language
An EJB query is a string that contains the following elements:
- a SELECT clause that specifies the
EJBs or values to return;
- a FROM clause that names the bean collections;
- an optional WHERE clause that contains
search predicates over the collections;
- an optional GROUP BY and HAVING clause (see Aggregation
functions);
- an optional ORDER BY clause that
specifies the ordering of the result collection.
The SELECT clause is optional in order to maintain compatibility with
WebSphere Application Server Version 4.
Collections of entity beans are identified in EJB queries through the use
of their abstract schema name in the query FROM clause.
The elements of EJB query language are discussed in more detail in the
following related topics.

FROM clause
Inheritance in EJB query
Path expressions
WHERE clause
Scalar functions
Aggregation functions
SELECT clause
ORDER BY clause
Subqueries
EJB query restrictions

Using EJB query

Example: EJB queries
EJB query: Reserved words
EJB query: BNF syntax
Comparison of EJB 2.0 specification and WebSphere query language
Searchable topic ID:
cque_langdef
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_langdef.html