WebSphere Application Server Network Deployment, Version 6.0.x   Operating Systems: AIX, HP-UX, Linux, Solaris, Windows
             [TIP: Focusing the table of contents and search results]

Scalar functions

An Enterprise JavaBeans (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: Mar 8, 2007 8:14:28 PM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/cque_scalar.html

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