Scalar functions
An 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) = 1999The 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
Use EJB query