RDBMS : JDOQL Methods specific to RDBMS

We have already seen the standard JDOQL methods supported for all datastores. With RDBMS we provide support for some additional methods.

Java Type Method Description Specification
String trimLeft() Returns a trimmed version of the string (trimmed for leading spaces)
String trimRight() Returns a trimmed version of the string (trimmed for trailing spaces)
{} length Returns the length of an array
{} contains(object) Returns true if the array contains the object
SQL_rollup({object}) Perform a rollup operation over the results. Only available for some datastores e.g DB2, MSSQL, Oracle
SQL_cube({object}) Perform a cube operation over the results. Only available for some datastores e.g DB2, MSSQL, Oracle
SQL_boolean({sql}) Embed the provided SQL and return a boolean result
SQL_numeric({sql}) Embed the provided SQL and return a numeric result

Please note that you can easily add support for other methods using a DataNucleus plugin point