EJB Query Scalar functions

An EJBs 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

Use EJB query