Scalar functions

EJB query contains scalar built-in functions for doing type conversions, string manipulation, and for manipulating date-time values. The list of scalar functions is documented in the topic EJB query: Scalar functions.

Example: Scalar functions

Find employees hired in 1999:

SELECT OBJECT(e) FROM EmpBean e where YEAR(e.hireDate) = 1999

The only scalar functions that are guaranteed to be portable across backend datastore vendors are the following:

The other scalar functions should be used only when DB2 is the backend datastore.


Related concepts
EJB query language
Related tasks
Using EJB query



Searchable topic ID:   cque_scalar
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/ae/cque_scalar.html

Library | Support | Terms of Use | Feedback