WebSphere Application Server - Express, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Scalar functions

EJB query contains scalar 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:
  • ABS
  • MOD
  • SQRT
  • CONCAT
  • LENGTH
  • LOCATE
  • SUBSTRING
  • UCASE
  • LCASE

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




Sub-topics
EJB query: Scalar functions

Related concepts
EJB query language

Related tasks
Using EJB query

Concept topic    

Terms of Use | Feedback

Last updated: Jun 8, 2005 12:45:23 PM EDT
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/cque_scalar.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)