skip to main content
Supported scalar functions
 

Try DataDirect Cloud Now

Supported scalar functions

Applications accessing cloud data should use supported scalar functions, which differ, depending on the data store you are accessing. Each scalar function returns a single value based on the input value. The SQLGetInfo function returns information about supported functions.
Applications can construct SQL statements using the following syntax, where scalar-function is one of the functions listed in the topic for your data store.
{fn scalar-function}
For example:
SELECT {fn
UCASE(NAME)} FROM EMP
* Scalar function support for Amazon Redshift
* Scalar function support for Apache Hive
* Scalar function support for DB2
* Scalar function support for Google Analytics
* Scalar function support for Greenplum
* Scalar function support for HubSpot
* Scalar function support for Informix
* Scalar function support for Marketo
* Scalar function support for Microsoft Dynamics CRM
* Scalar function support for Microsoft SQL Server
* Scalar function support for MySQL
* Scalar function support for Oracle
* Scalar function support for Oracle Eloqua
* Scalar function support for Oracle Marketing Cloud
* Scalar function support for Oracle Service Cloud
* Scalar function support for PostgeSQL
* Scalar function support for Progress OpenEdge
* Scalar function support for Progress Rollbase
* Scalar function support for Salesforce-based data stores
* Scalar function support for SugarCRM
* Scalar function support for Sybase