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.

 

See also


EJB query: Scalar functions

 

See Also


EJB query language

 

Related Tasks


Using EJB query