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.




Subtopics
EJB query: Scalar functions
Related concepts
EJB query language
Related tasks
Using EJB query
Concept topic Concept topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 8:21:57 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-express-iseries&topic=cque_scalar
File name: cque_scalar.html