The driver supports all the scalar functions supported by Google BigQuery.
Refer to the Google documentation to see the complete list of supported scalar functions. In addition, you can also determine the supported scalar functions by using DatabaseMetaData methods.
You can use scalar functions in SQL statements with the following syntax:
{fn scalar-function}
where:
scalar-function
is a scalar function supported by the drivers, as listed in the following table.
Example:
SELECT id, name FROM emp WHERE name LIKE {fn UCASE('Smith')}
For descriptions of scalar functions, refer to Scalar Functions in the Progress DataDirect for JDBC Drivers Reference.
