Scalar functions are specific to each type of data store. Refer to the documentation for the data source to which you are connection.
The driver supports a variety of scalar functions, which return 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:
{fn scalar-function}
For example:
SELECT {fn UCASE(NAME)} FROM EMP
Applications connecting through JDBC can use the following scalar functions in expressions. For syntax details, consult your JDBC documentation.
