WAS v8.5 > Develop applications > Develop Dynamic and EJB query > Develop applications that use EJB query > EJB query language

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) = 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
  EJB query contains scalar built-in functions for doing type conversions, string manipulation, and for manipulating date-time values.
• EJB query: Scalar functions
  EJB query contains scalar built-in functions for doing type conversions, string manipulation, and for manipulating date-time values.

Related concepts:

EJB query language

Related

Use EJB query

+

Search Tips   |   Advanced Search